ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / SQL functions
  • 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/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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 (for more details, see Types of SQL browse).
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. For more details, see Accessing a database in local mode (SQLite).
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
Query name: 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.
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 and PHP, the SQL.NbLine variable will be filled only if SQLFirst was called before SQLInfo.
WINDEVWEBDEV - Server codeWEBDEV - Browser codeWindowsJavaUser code (UMC)PHPAjax

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.
WEBDEV - Browser code Remark: 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).
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/03/2023

Send a report | Local help