RecordSet Class Reference


RecordSet class is an implicit instance returned by Database:SQLSelect(sql) method. Please take a look at the examples section for more details.
Method Description
EOF True when the record pointer is at the end of the set of records.
ColumnCount The number of fields in the RecordSet.
RecordCount The number of records in the RecordSet.
MoveFirst Moves the record pointer to the first record in the RecordSet.
MoveLast Moves the record pointer to the last record in the RecordSet.
MoveNext Moves the record pointer to the next record in the RecordSet.
MovePrevious Moves the record pointer to the previous record in the RecordSet.
Name Returns the name of the field passed as parameter (1 based).
Value Returns the value of the field passed as parameter (1 based) in the row the record pointer is pointing to.