Library: Database access (OMDB legacy)
define external function dbRecordMove read-only dbField record
dbFieldshelf bound to a record set created by an SQL query
dbRecordMove to change the position of the data cursor within the specified record set.
You must include the following line at the beginning of your OmniMark program:
The database connection used to obtain record must be
dbField shelf record must be associated with a query (else external exception OMDB302).
dbField shelf record must exist.
The data cursor points to the currently active row of the record set. The cursor advances to the next row of the record set.
You can move the data cursor beyond the record set boundaries. However, if you attempt to retrieve a field
value in this situation, external exception OMDB205 will be thrown. Hint: Before attempting to retrieve field
values, you should use the
dbRecordExists function to verify that the data cursor is within the record
What sort of cursor movement is possible depends on the database and database interface being used.
repeat exit unless dbRecordExists my-query repeat over my-query output dbFieldValue my-query null '-DNF-' output '%t' unless #last again output '%n' dbRecordMove my-query again