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

Declaration

  define external function dbCommit
         value dbDatabase database

Argument definitions

database

is a dbDatabase object obtained by opening a connection to a database using one of the dbOpen functions.

Use dbCommit to commit all the insert, delete, or update operations performed since the last dbCommit or dbRollback.

Requirements

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

  include "omdb.xin"

The dbDatabase object database must be:

• open (else external exception OMDB101)
• in scope (else external exception OMDB103)

Usage Notes

You may call the dbCommit function if the transaction type for the database is autocommit without generating an exception.

Example

  process

      local dbDatabase this-db
      local dbTable course
      local stream SQL-insert initial
      {  "insert into Course values " ||
          " ( '503', 'Learning Through Pain'  )"
      }

      local stream course-data variable initial
      {   '504' with key 'cid',
            'What is that Sound?' with key 'CourseName'
      }

      set this-db to dbOpenODBC 'dbDemo'
      set course to dbTableOpen this-db table 'Course'
      dbSetTransactionType this-db to DB_MANUAL_COMMIT

      dbExecute this-db sql SQL-insert

      dbTableInsert course from course-data

      dbCommit this-db

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 ]