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

Return type: Switch Returns:

Declaration

  define external function dbRecordSetMove
        modifiable dbField  record

Argument definitions

record

is a dbField shelf.

Use dbRecordSetMove to see if there is another result set.

Requirements

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

  include "omdb.xin"

The database connection represented by dbDatabase must be open (else external exception OMDB104).

Usage Notes

This procedure is useful when stored procedures produce mulitple result sets.

Example

The outermost tests for multiple result sets.

  dbProcedureExecute proc
       result rset
  repeat
       output "<result-set>%n"
       repeat
           exit unless dbRecordExists rset
           output "%n<record "
           repeat over rset
               output "%n%t" || key of rset || '= "' ||
                   dbFieldValue rset || '"'
           again
           output "/>%n"
           dbRecordMove rset
       again
       exit unless dbRecordSetMove rset
       output "</result-set>%n"
  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    dbRecordSetMove    dbRollback    dbSetTransactionType    dbStatement    dbStatementCompile    dbStatementDiscard    dbStatementExecute    dbStatementStreamingExecute    dbTable    dbTableClose    dbTableDelete    dbTableInsert    dbTableOpen    dbTableUpdate

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