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.
// 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
<Query name>: Character string
Query name: