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

Return type: Switch Returns: True or false.

Declaration

define external switch function dbRecordExists
  read-only dbField record

Argument definitions

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

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 dbRecordMoveDynamic dbRecordSetMove dbRollback dbSetTransactionType dbStatement dbStatementCompile dbStatementDiscard dbStatementExecute dbStatementStreamingExecute dbTable dbTableClose dbTableDelete dbTableInsert dbTableOpen dbTableUpdate

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