![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)
Содержание 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...