![background image](http://html1.mh-extra.com/html/omron/cx-supervisor-script-reference-rev2-0/cx-supervisor-script-reference-rev2-0_reference-manual_744212125.webp)
CHAPTER 6 – Functions and Methods
OMRON
Page 112
Revision 2.0
DBClose
Description
Closes a Connection or Recordset. Closing a Connection will automatically close all recordsets
associated with it. Recordsets can be closed in isolation by selecting the appropriate level.
Syntax
returnstate = DBClose(level)
Remarks
Argument
Type
Description
returnstate
bool
1 if the function is successful otherwise 0
level
text
A text point or constant specifying the connection level. This
should be a connection or recordset level.
Typical Examples
Result = DBClose("Northwind.Order Details")
Closes the 'Order Details' Recordset
Result = DBClose("Northwind")
Closes the connection to the Northwind database, and also any Recordsets which may be open.
DBDelete
Description
Deletes the specified number of records from the current record position. This function works only at
the Recordset level. This function will fail if the Recordset is opened with a lock of 'Read Only'.
Syntax
returnstate = DBDelete(level, quantity)
Remarks
Argument
Type
Description
returnstate
bool
1 if the function is successful otherwise 0
level
text
A text point or constant specifying the connection level. This
must be a recordset level.
quantity
int
Number of records to delete.
Typical Examples
Result = DBDelete("Northwind.Order Details", 10)
Summary of Contents for CX-SUPERVISOR - SCRIPT REFERENCE REV2.0
Page 2: ...CX Supervisor Script Language Software Revision 2 0...
Page 3: ......
Page 5: ...CX Supervisor Script Language OMRON Page ii Revision 2 0...
Page 7: ...CX Supervisor Script Language OMRON Page iv Revision 2 0...
Page 9: ...CX Supervisor Script Language OMRON Page vi Revision 2 0...
Page 13: ......
Page 15: ...CHAPTER 1 Introduction OMRON Page 2 Revision 2 0...
Page 19: ...CHAPTER 2 Expressions OMRON Page 6 Revision 2 0...
Page 21: ...CHAPTER 3 Scripts OMRON Page 8 Revision 2 0...
Page 151: ...CHAPTER 8 Colour Palette OMRON Page 138 Revision 2 0...