dbRecordMove

function

Library: Database access (OMDB legacy)
Include: omdb.xin

Declaration

define external function 
   dbRecordMove read-only dbField record

Argument definitions

record: is a dbField shelf bound to a record set created by an SQL query

Purpose

Use dbRecordMove to change the position of the data cursor within the specified record set.

Requirements

You must include the following line at the beginning of your OmniMark program:

  include "omdb.xin"

The database connection used to obtain record must be

open (else external exception OMDB209), and
in scope (else external exception OMDB103).

The dbField shelf record must be associated with a query (else external exception OMDB302).

The dbField shelf record must exist.

Usage Notes

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.

Example

  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