 |
 |
|
|
       |
|||
|
||||||||||
|
|
||||||||||
| Other Library Functions | ||||||||||
| function | dbRecordMove |
|
Library: omdb - high level database access
Include: omdb.xin |
define external function dbRecordMove
read-only dbField record
by value integer increment optional
to value integer absolute optional
Where:
increment
absolute
The dbRecordMove function changes the position of the data cursor within the specified record set. The data cursor points to the currently active row of the record set. By default, the cursor advances one position. You can move the data cursor beyond the record set boundaries, but an exception will occur if you attempt to retrieve a field value in this situation.
Before attempting to retrieve field values, you should use the dbRecordExists function to verify that the data cursor is within the record set boundaries. For example:
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
Note that you should use either the increment or the absolute argument, not both. If you use both, an exception will be thrown.
| ---- |
