Other Library Functions

function

dbRecordExists

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

A dbField shelf attached to an SQL query.

Purpose

The dbRecordExists function is used to check whether the data cursor is positioned on an existing row. The data cursor points to the record set's currently active row. The function returns a switch value, which is true when the data cursor is on an existing row, and false otherwise. The function uses the dbField OMX shelf variable in which a dbQuery function stored the record set earlier. For 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    dbExecute    dbFieldValue    dbIsVersionCompatible    dbLibraryVersion    dbOpenODBC    dbQuery    dbRecordExists    dbRecordMove    dbTableClose    dbTableDelete    dbTableInsert    dbTableOpen    dbTableUpdate

----

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

Copyright © OmniMark Technologies Corporation, 1988-2000.