|
|||||
|
||||||
Related Topics | Other Library Functions |
function |
db.move-record |
Library: Database access (OMDB)
Import: omdb.xmd |
define external function db.move-record read-only db.field record
Argument definitions
Use db.move-record to advance the data cursor within the specified record set.
The database connection represented by db.database must be
The db.field shelf must be associated with a query (else external exception OMDB302).
The db.field shelf record must exist.
The data cursor points to the currently active row of the record set. This function advances the cursor 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. Before attempting to retrieve field values, you should use the db.record-exists
function to verify that the data cursor is within the record set boundaries.
This function works on result sets created with either static or dynamic cursors. However, using a static cursor is recommended, as it is substantially more efficient than a dynamic cursor.
repeat exit unless db.record-exists my-query repeat over my-query output db.reader of my-query null '-DNF-' output '%t' when ! #last again output '%n' db.move-record my-query again
Copyright © Stilo International plc, 1988-2010.