Error getting tags :
error 404Error getting tags :
error 404 revdb_execute | revDocs | RunRev
Welcome Guest (Log in)
Product Edition
Version
revdb_execute
Basics
Expander triangle
Type
Function
Syntax

revdb_execute(databaseID,SQLQuery[,variablesList])

Introduced
1.1
Environment
Desktop, Web and Server
Platform Support
MacOS,Mac OS X,Windows,Linux
Security
Disk,Network
Summary
Executes the revExecuteSQLcommand.
Examples

revdb_execute(myDatabaseID,field "Query","*b" & "myvar")

Additional Comments
Expander triangle

Use the revdb_execute function to execute a SQL query without selecting records.

Parameters:

The databaseID is the number returned by the revOpenDatabase function when the database was opened.

The SQLQuery is a string in Structured Query Language.

The variablesList consists of one or more variable names (or expressions that evaluate to variable names), separated by commas.

Value:

The revdb_execute function returns the number of rows operated on by the SQLQuery.

Comments:

Evaluating the revdb_execute function has the same effect as executing the revExecuteSQL command. The only difference is that one is a function call and the other is a command.

Important! The revdb_executefunction is part of the Database library. To ensure that the function works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions section of the General screen of the Standalone Application Settings window, make sure the "Database Support" checkbox is checked and the database drivers you are using are selected in the list of database drivers.

User Comments
Expander triangle