Library: Database access (OMDB) Import: omdb.xmd

Declaration

define external  function db.move-record
       read-only db.field  record

Argument definitions

record

is a db.field shelf bound to a record set created by a SQL query

Use db.move-record to advance the data cursor within the specified record set.

Requirements

The database connection represented by db.database must be

• open (else external exception OMDB209).
• in scope (else external exception OMDB103).

The db.field shelf must be associated with a query (else external exception OMDB302).

The db.field shelf record must exist.

Usage Notes

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.

Example

        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

Related Syntax    db.query    db.record-exists    db.reader    db.field    db.compile-statement    db.move-dynamic-record

Related Concepts    Using the OMDB library

Other Library Functions    db.advance-recordset    db.close    db.commit    db.compile-statement    db.database    db.delete    db.discard    db.document-writer-sedna    db.execute    db.execute-in    db.field    db.insert    db.is-null    db.move-dynamic-record    db.move-record    db.omdb-version    db.omdb-version-oci10g    db.omdb-version-oci11g    db.omdb-version-oci8i    db.omdb-version-oci9i    db.omdb-version-odbc    db.omdb-version-sedna    db.open-oci10g    db.open-oci11g    db.open-oci8i    db.open-oci9i    db.open-odbc    db.open-procedure    db.open-sedna    db.open-table    db.prepare    db.procedure    db.query    db.reader    db.record-exists    db.rollback    db.set-transaction-type    db.statement    db.streaming-execute    db.table    db.update    db.writer

[ INDEX ] [ CONCEPTS ] [ TASKS ] [ SYNTAX ] [ LIBRARIES ] [ LEGACY LIBRARIES ] [ ERRORS ]