SQLClose (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

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.

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). See Accessing a database in local mode (SQLite) for more details.

New in version 16

This function is now available in Browser code.

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

This function is now available in Browser code.

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

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 (with or without quotes)

Query name:
created and run by SQLExec (with quotes),
run by SQLExecWDR (with or without 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.

Component : wd250hf.dll