PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Information updated if the parameter is not specified
  • Information updated if the parameter is specified and the browse is performed by SQLFirst/SQLCol
  • Information updated if the parameter is specified and the browse is performed by SQLFetch/SQLGetCol
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Initializes the different SQL variables with information relative to the last query run. This function can be used regardless of the type of browse performed (see Types of SQL browse for more details).
Versions 16 and later
WEBDEV - Browser code This function is now available in Browser code.
WEBDEV - Browser code The SQL functions are used to handle the local databases (such as Web SQL databases). Only the SQLFetch/SQLGetCol browse mode is available. See Accessing a database in local mode (SQLite) for more details.
New in version 16
WEBDEV - Browser code This function is now available in Browser code.
WEBDEV - Browser code The SQL functions are used to handle the local databases (such as Web SQL databases). Only the SQLFetch/SQLGetCol browse mode is available. See Accessing a database in local mode (SQLite) for more details.
WEBDEV - Browser code This function is now available in Browser code.
WEBDEV - Browser code The SQL functions are used to handle the local databases (such as Web SQL databases). Only the SQLFetch/SQLGetCol browse mode is available. See Accessing a database in local mode (SQLite) for more details.
Versions 19 and later
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).
New in version 19
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Example
ResSQL = SQLExec("SELECT * FROM INV", "QRY1")
IF ResSQL = False THEN
SQLInfo("QRY1")
Info("SQL error: " + SQL.MesError)
ELSE
SQLTable("QRY1", TABLE_Table1)
END
SQLClose("QRY1")
Syntax
SQLInfo([<Query Name>])
<Query Name>: Optional character string (with or without quotes)
Query Name:
  • created and run by SQLExec (with quotes),
  • run by SQLExecWDR (with or without quotes).
An error is generated if this parameter corresponds to a query that does not exist. To check the query existence, use SQLReqExists.
Java The queries created with the query editor must be specified in the format of a character string with quotes.
Versions 16 and later
WEBDEV - Browser code Only the queries created and run by SQLExec are available.
New in version 16
WEBDEV - Browser code Only the queries created and run by SQLExec are available.
WEBDEV - Browser code Only the queries created and run by SQLExec are available.
Remarks

Information updated if the <Query Name> parameter is not specified

VariableTypeDescription
SQL.BaseCharacter stringName of database to which the project is connected.
SQL.ConnectionIntegerIdentifier of current connection (returned by SQLConnect).
SQL.ErrorCharacter string
  • Error code ("00000" if no error). See the documentation about the driver to find out its meaning.
  • Non-existing error code for the connections with the native ORACLE or SQL SERVER drivers of PC SOFT.
SQL.MesErrorCharacter stringCaption of error.
SQL.NbColIntegerNumber of result columns.
If the <Query Name> parameter is not specified, SQLInfo must be called after the connection (SQLConnect)

Information updated if the <Query Name> parameter is specified and the browse is performed by SQLFirst/SQLCol

VariableTypeDescription
SQL.BaseCharacter stringName of database to which the project is connected.
SQL.ConnectionIntegerIdentifier of current connection (returned by SQLConnect).
SQL.OutBooleanUsed to find out if there are more records to read.
SQL.CurrentIntegerNumber of current row in the query result.
SQL.ErrorCharacter string
  • Error code ("00000" if no error). See the documentation about the driver to find out its meaning.
  • Non-existing error code for the connections with the native ORACLE or SQL SERVER drivers of PC SOFT.
SQL.MesErrorCharacter stringCaption of error. See the documentation about the driver to find out its meaning.
SQL.NbColIntegerNumber of result columns.
SQL.NbLineIntegerNumber of result rows.
SQL.RetrievingBoolean
  • True if the result is currently retrieved (case of partial fetch),
  • False if the entire result is retrieved.
SQL.QueryIntegerNumber of current query.
SQL.TitleCol [n]Character stringDefault title of specified column.
If the <Query Name> parameter is specified:
  • SQLInfo must be called after the query execution (SQLExec).
  • In Java, the SQL.NbLine variable will be filled only if SQLFirst was called before SQLInfo.
WINDEVWEBDEV - Server codeWEBDEV - Browser codeWindowsJavaPHPAjaxUser code (UMC)

Information updated if the <Query Name> parameter is specified and the browse is performed by SQLFetch/SQLGetCol

VariableTypeDescription
SQL.BaseCharacter stringName of database to which the project is connected.
SQL.ConnectionIntegerIdentifier of current connection (returned by SQLConnect).
SQL.ErrorCharacter string
  • Error code ("00000" if no error). See the documentation about the driver to find out its meaning.
  • Non-existing error code for the connections with the native ORACLE or SQL SERVER drivers of PC SOFT. For the local browser databases, see the documentation about the "Web SQL database".
SQL.MesErrorCharacter stringCaption of error. See the documentation about the driver to find out its meaning.
SQL.NbColIntegerNumber of result columns.
Versions 16 and later
WEBDEV - Browser code Note: to get this information, a result must have been returned by the query.
New in version 16
WEBDEV - Browser code Note: to get this information, a result must have been returned by the query.
WEBDEV - Browser code Note: to get this information, a result must have been returned by the query.
SQL.QueryIntegerNumber of current query.
SQL.TitleCol [n]Character stringDefault title of specified column.
If the <Query Name> parameter is specified, SQLInfo must be called after the query execution (SQLExec).
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
WEBDEV - Browser code WDJS.DLL
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment