|
|
|
|
|
|
|
|
|
|
- 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.
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). 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 <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. Remarks Information updated if parameter 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|