ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / SQL functions
  • Information updated if 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 route is performed with SQLFetch/SQLGetCol.
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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 FACT", "REQ1")
IF ResSQL = False THEN
	SQLInfo("REQ1")
	Info("Erreur SQL: " + SQL.MesError)
ELSE
	SQLTable("REQ1", TABLE_Table1)
END
SQLClose("REQ1")
Syntax
SQLInfo([<Query name>])
<Query name>: Optional character string
Name of the query: 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 parameter is not specified

VariableTypeDescription
SQL.BaseCharacter stringName of database to which the project is connected.
SQL.ConnectionentierIdentifier 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.NbColentierNumber 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.ConnectionentierIdentifier of current connection (returned by SQLConnect).
SQL.OutBooleanUsed to find out if there are more records to read.
SQL.CurrententierNumber 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.NbColentierNumber of result columns.
SQL.NbLineentierNumber of result rows.
SQL.RetrievingBoolean
  • True if the result is currently retrieved (case of partial fetch),
  • False if the entire result is retrieved.
SQL.QueryentierNumber 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 parameter is specified and the route is performed with SQLFetch/SQLGetCol.

VariableTypeDescription
SQL.BaseCharacter stringName of database to which the project is connected.
SQL.ConnectionentierIdentifier 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.NbColentierNumber of result columns.
WEBDEV - Browser code Note: to obtain this information, the query must have returned a result.
SQL.QueryentierNumber 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: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/19/2024

Send a report | Local help