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

Return type: Switch Returns: TRUE if the data cursor points to a valid row, or FALSE otherwise.

Declaration

define external switch function db.record-exists
  read-only db.field record

Argument definitions

record

is a db.field shelf.

Use db.record-exists to check whether or not the data cursor is positioned on an existing row.

Usage Notes

The data cursor points to the record set's currently active row.

The function uses a db.field shelf variable in which a db.query, db.execute or db.streaming-execute stored the record set.

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.move-record    db.reader    db.field

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 ]