OMRON
CHAPTER 6 – Functions and Methods
Revision 2.0
Page 121
Remarks
Argument
Type
Description
return
Value returned by command. For some commands e.g.
"RecordCount" this is an integer value, for other commands this
is a text value.
level
text
A text point or constant specifying the connection level. This
must be a Schema level.
command
text
The command must be one of the following:
"Read"
- Transfers a schema page into the
associated point
"Set"
- Enables schema details to be modified
"Type"
- Returns the current Schema Type
"Criteria"
- Returns the current Schema Criteria
"Filter"
- Returns the current Schema Filter
"RecordCount"
- Returns the number of records in the
current Schema
"PageCount"
- Returns the number of pages in the current
Schema
"CurrentPage"
- Returns the current Schema page
parameters
Some commands require 1 or more extra parameters. "Read"
takes an optional parameter ‘Page Number’ of type integer. If
no ‘Page Number’ is supplied, this function will return page 1
when first called and automatically return the next page of
schemas for each subsequent call, cycling back to the beginning
when all pages have been returned.
"Set" takes three text parameters for Schema ‘Name’, ‘Criteria’
and ‘Filter’.
Typical Examples
NumberOfRecords = DBSchema("Invoice.Data Types", "RecordCount")
Read the Number of records in the Schema.
DBSchema("Invoice.Data types", "Read", 2)
Read Schema page 2 results into the associated point.
DBSchema("Invoice.Data Types", "Set", "Columns", "COLUMN_NAME", "")
Set a new Schema to return column names.
DBState
Description
Reports if the specified level is in the requested state.
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...