SQLClose (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

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 release of a request is mandatory, even if the execution of the request has 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

// Exécution de la requête et récupération des informations
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

SQLClose(<Query name>)

<Query name>: Character string

Name of the query:
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