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

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

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.

Component : wd260hf.dll