Omron CX-Supervisor Reference Manual

Database Commands SECTION 6 Functions and Methods
109
Typical Examples
Page = DBProperty("CSV.Result", "CurrentPage")
Get the current page for the CSV.Result Recordset.
FieldSize = DBProperty("Northwind.Customers.Address",
"Size")
Get the size for the 'Address' field.
Recordset Properties
The properties of a Recordset are:
Field Properties
The properties of a Field are
6-17-9 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
property text The name of the property to get. For details
see the Recordset Properties and Field
Properties tables.
Argument Type Description
Note: The Recordset will only return valid properties when it is Open.
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
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

Omron CX-Supervisor Specifications

General

Brand	Omron
Model	CX-Supervisor
Category	Software
Language	English