Related Syntax	Related Concepts	Other Library Functions

Library: omdb - high level database access Include: omdb.xin

Return type: Switch Returns:        True or false.

Declaration

  define external switch function dbRecordExists
    read-only dbField record

  where

record

is a dbField shelf.

Use dbRecordExists to check whether or not the data cursor is positioned on an existing row.

Requirements

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

  include "omdb.xin"

Usage Notes

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

The function uses a dbField shelf variable in which a dbQuery function stored the record set earlier.

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

Related Syntax    dbQuery    dbRecordMove    dbField

Related Concepts    Using the OMDB library

Other Library Functions    dbClose    dbCommit    dbDatabase    dbExecute    dbField    dbFieldPrepare    dbFieldSink    dbFieldValue    dbIsVersionCompatible    dbLibraryVersion    dbLibraryVersionOCI8    dbLibraryVersionOCI8i    dbLibraryVersionODBC    dbOpenOCI8    dbOpenOCI8i    dbOpenODBC    dbProcedure    dbProcedureClose    dbProcedureExecute    dbProcedureOpen    dbQuery    dbRecordExists    dbRecordMove    dbRecordSetMove    dbRollback    dbSetTransactionType    dbStatement    dbStatementCompile    dbStatementDiscard    dbStatementExecute    dbStatementStreamingExecute    dbTable    dbTableClose    dbTableDelete    dbTableInsert    dbTableOpen    dbTableUpdate

----

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

Copyright © OmniMark Technologies Corporation, 1988-2002.