ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / SQL functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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).
Caution: The query must necessarily be freed even if the query execution failed.
WEBDEV - Browser code 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:
Java The queries created with the query editor must be specified in the format of a character string.
WEBDEV - Browser code Only the queries created and run by SQLExec are available.
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help