SQLInfo (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

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 (see Types of SQL browse for more details).

Versions 16 and later

This function is now available in 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

This function is now available in Browser code.

Versions 19 and later

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for Android applications (accessing the external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).

New in version 19

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for Android applications (accessing the external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for Android applications (accessing the external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

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.
The queries created with the query editor must be specified in the format of a character string with quotes.
Versions 16 and later
Only the queries created and run by SQLExec are available.
New in version 16
Only the queries created and run by SQLExec are available.
Only the queries created and run by SQLExec are available.

Remarks

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

Variable	Type	Description

SQL.Base	Character string	Name of database to which the project is connected.
SQL.Connection	Integer	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	Integer	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	Integer	Identifier of current connection (returned by SQLConnect).
SQL.Out	Boolean	Used to find out if there are more records to read.
SQL.Current	Integer	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	Integer	Number of result columns.
SQL.NbLine	Integer	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	Integer	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 <Query name> parameter is specified and the browse is performed by SQLFetch/SQLGetCol

Variable	Type	Description

SQL.Base	Character string	Name of database to which the project is connected.
SQL.Connection	Integer	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	Integer	Number of result columns. Versions 16 and later Remark: to get this information, a result must have been returned by the query. New in version 16 Remark: to get this information, a result must have been returned by the query. Remark: to get this information, a result must have been returned by the query.
SQL.Query	Integer	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 : wd260hf.dll