|
|||||
|
||||||
Other Library Functions |
function |
dbRecordMove |
Library: Database access (OMDB legacy)
Include: omdb.xin |
define external function dbRecordMove read-only dbField record
Argument definitions
Use 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:
include "omdb.xin"
The database connection represented by dbDatabase must be
The dbField shelf must be associated with a query (else external exception OMDB302).
The 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 set boundaries.
What sort of cursor movement is possible depends on the database and database interface being used. If using the OCI8 or OCI8i interface, you can only advance to the next record. Some ODBC drivers allow additional flexibility.
repeat exit unless dbRecordExists my-query repeat over my-query output dbFieldValue my-query null '-DNF-' output '%t' when ! #last again output '%n' dbRecordMove my-query again
Copyright © Stilo International plc, 1988-2010.