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

Page: 127 / 195

CHAPTER 6 – Functions and Methods OMRON
Page 114 Revision 2.0
DBExecute("Northwind.Shippers", "Filter", "CompanyName = ‘United
Package’")
Apply a filter to display only records with a company name ‘United Package’
DBExecute("Northwind.Shippers", "Filter", "")
Cancel an existing filter (by passing an empty string)
DBExecute Commands
Command Connection
Level
Description
Connection Connection Modify the connection string.
BeginTrans Connection Begins a new Transaction.
CommitTrans Connection Saves any pending changes and ends the current
transaction.
RollbackTrans Connection Cancels any changes made and ends the transaction.
CommitTransAll Connection Saves all changes and ends all transactions.
RollbackTransAll Connection Cancels all changes and ends all transactions.
TransCount Connection Returns the number of pending transactions.
Requery Recordset Re-run the Recordset Query.
CancelUpdate Recordset Cancel a DBAddNew operation.
Find Recordset Find the specified criteria in a Recordset.
FinNext Recordset Combined DBMove("Next"), DBFind() operation.
Source Recordset Modify the Recordset source.
Filter Recordset Apply a filter to a Recordset.
Save Recordset Saves a Recordset in XML format.
DBGetLastError
Description
Returns the last error string generated by the Database provider, and displays it in a message box.
Syntax
returnstate = DBGetLastError(level, display)