ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / SQL functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Declares the end of execution of a query and frees the memory resources allocated during the execution of the query (SQLExec or SQLExecWDR).
Note: The memory allocated to the query must be released even if the query execution has failed.
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
Name of the query:
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/25/2025

Send a report | Local help