Omron CX-SUPERVISOR - SCRIPT REFERENCE REV2.0, Reference Manual

Page: 126 / 195

OMRON CHAPTER 6 – Functions and Methods
Revision 2.0 Page 113
Delete the next 10 records in the recordset
DBMove("First")
Result = DBDelete("Northwind.Order Details", 10)
Delete the first 10 records.
DBExecute
Description
The DBExecute function allows the execution of miscellaneous commands and allows for future
expansion by supporting new commands without the need to create more new DB functions.
Syntax
return = DBExecute(level, command, parameter)
Remarks
Argument Type Description
return 1 if the function is successful otherwise 0 except for "Find" and
"FindNext" commands which return the record number if found
or if not, set the current record to EOF and return -1.
level text A text point or constant specifying the connection level, which
depends on the command specified.
command text Command to execute. May be one of the commands listed
below.
parameter text Command parameter only required with certain commands. For
"Connection", this parameter should hold the new connection
string. For "Find" and "FindNext" this parameter should be the
search criteria. For "Source" this is the Recordset source. For
"Filter" this is the Recordset filter.
Typical Examples
Pos = DBExecute("Northwind.Order Details", "Find", "UnitPrice >
14.00")
Find the next record satisfying the specified criteria, starting from the current position. Valid search
criteria include: "ProductName LIKE ‘G*’ " wildcard search finds all records where ProductName
starts with ‘G’, "Quantity = 5", "Price >= 6.99". Only single search values are allowed, using
multiple values with ‘AND’ or ‘OR’ will fail.
DBExecute("Connection1.Recordset1", "Source", "Table2")
Modify the Recordsets source to open a different table than configured.