SQLInfo (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WEBDEV

WINDEV Mobile

Others

See also

SQLInfo (Function)

In french: SQLInfoGene

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).

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:
created and run by SQLExec,
run by SQLExecWDR.
An error is generated if this parameter corresponds to a query that does not exist. To check the query existence, use SQLReqExists.
The queries created with the query editor must be specified in the format of a character string.
Only the queries created and run by SQLExec are available.

Remarks

Information updated if parameter <Nom de la requête> is not specified

Variable	Type	Description

SQL.Base	Character string	Name of database to which the project is connected.
SQL.Connection	entier	Identifier of current connection (returned by SQLConnect).
SQL.Error	Character 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.MesError	Character string	Caption of error.
SQL.NbCol	entier	Number 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

Variable	Type	Description

SQL.Base	Character string	Name of database to which the project is connected.
SQL.Connection	entier	Identifier of current connection (returned by SQLConnect).
SQL.Out	Boolean	Used to find out if there are more records to read.
SQL.Current	entier	Number of current row in the query result.
SQL.Error	Character 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.MesError	Character string	Caption of error. See the documentation about the driver to find out its meaning.
SQL.NbCol	entier	Number of result columns.
SQL.NbLine	entier	Number of result rows.
SQL.Retrieving	Boolean	True if the result is currently retrieved (case of partial fetch), False if the entire result is retrieved.
SQL.Query	entier	Number of current query.
SQL.TitleCol [n]	Character string	Default 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.

Information updated if the <Nom de la requête> parameter is specified and the route is performed with SQLFetch/SQLGetCol.

Variable	Type	Description

SQL.Base	Character string	Name of database to which the project is connected.
SQL.Connection	entier	Identifier of current connection (returned by SQLConnect).
SQL.Error	Character 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.MesError	Character string	Caption of error. See the documentation about the driver to find out its meaning.
SQL.NbCol	entier	Number of result columns. Note: to obtain this information, the query must have returned a result.
SQL.Query	entier	Number of current query.
SQL.TitleCol [n]	Character string	Default title of specified column.

If the <Query name> parameter is specified, SQLInfo must be called after the query execution (SQLExec).

Component: wd300hf.dll