![background image](http://html1.mh-extra.com/html/omron/cx-supervisor-script-reference-rev2-0/cx-supervisor-script-reference-rev2-0_reference-manual_744212127.webp)
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)
Содержание CX-SUPERVISOR - SCRIPT REFERENCE REV2.0
Страница 2: ...CX Supervisor Script Language Software Revision 2 0...
Страница 3: ......
Страница 5: ...CX Supervisor Script Language OMRON Page ii Revision 2 0...
Страница 7: ...CX Supervisor Script Language OMRON Page iv Revision 2 0...
Страница 9: ...CX Supervisor Script Language OMRON Page vi Revision 2 0...
Страница 13: ......
Страница 15: ...CHAPTER 1 Introduction OMRON Page 2 Revision 2 0...
Страница 19: ...CHAPTER 2 Expressions OMRON Page 6 Revision 2 0...
Страница 21: ...CHAPTER 3 Scripts OMRON Page 8 Revision 2 0...
Страница 151: ...CHAPTER 8 Colour Palette OMRON Page 138 Revision 2 0...