SQLClose (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / SQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLClose (Function)

In french: SQLFerme

Declares the end of execution of a query and frees the memory resources allocated during the execution of the query (SQLExec or SQLExecWDR).

Caution: The query must necessarily be freed even if the query execution failed.

The SQL functions are used to handle the local databases (such as Web SQL databases). For more details, see Accessing a database in local mode (SQLite).

Example

// Run the query and retrieve the information
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

SQLClose(<Query name>)

<Query name>: Character string

Query name:
created and run by SQLExec,
run by SQLExecWDR.
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.

Component: wd300hf.dll