OMRON
CHAPTER 6 – Functions and Methods
Revision 2.0
Page 119
Property
Description
Return type
"CurrentRecord"
Current cursor position
Integer
"RecordCount"
Number of records in the Recordset.
Integer
"Bookmark"
Record marker.
Real
"PageCount"
Number of pages in the Recordset.
Integer
"PageSize"
Number of records in a page.
Integer
"CurrentPage"
Page in which the cursor position resides.
Integer
"Source"
Command or SQL that created the Recordset.
Text
"Sort"
Field name(s) the Recordset is sorted on.
Text
"FieldCount"
Number of fields(columns) in the Recordset.
Integer
"BOF"
Current position is at the start of the Recordset.
Bool
"EOF"
Current position is at the end of the Recordset.
Bool
Field Properties
The properties of a Field are
Property
Description
Return type
"Value"
Value of the field at the current position.
As type of field
"Name"
Name of the Field.
String
"Type"
The fields data type.
String
"Size"
Maximum width of the field.
Integer
DBRead
Description
Reads a record from a Recordset to the associated point(s), or if associated points are array points,
reads a whole page of records. This function operates on both Recordset and Field levels. At the
Field level the associated column values from the Recordsets current position will be copied into the
Point (number of elements copied = number of elements in the Point, no paging applies at the Field
level).
Syntax
returnstate = DBRead(level, reset)
Содержание 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...