executes the revExecuteSQL command.
# Metadata
Platforms: desktop, server, mobile OS: mac, windows, linux, ios, android Introduced: 1.1 Security: disk, network
# Syntax
revdb_execute(databaseID, SQLQuery [, variablesList])
# Params
- databaseID : The number returned by the revOpenDatabase function when the database was opened. - SQLQuery : A string in Structured Query Language. - variablesList : The variablesList consists of one or more variable names (or expressions that evaluate to variable names), separated by commas.
# Examples
revdb_execute(myDatabaseID,field "Query","*b" & "myvar")
# Description
Use the revdb_execute function to execute a SQL query without selecting records.
Evaluating the revdb_execute function has the same effect as execute the revExecuteSQL command. The only difference is that one is a function call and the other is a command.
>*Important:* The revdb_execute function is part of the > Database library. To ensure that the function works in a > standalone application, you must include this > LiveCode custom library when you create your > standalone application. In the Inclusions pane of the > Standalone Application Settings window, make sure both the > "Database" library checkbox and those of the database drivers you are > using are checked.
# Tags
# See
- **control structure:** function - **command:** revExecuteSQL - **glossary:** execute, record, Standalone Application Settings, standalone application, function call, SQL query, command, LiveCode custom library - **library:** Database library