Library: Database access (OMDB legacy) 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 dbRecordMoveDynamic dbRecordSetMove dbRollback dbSetTransactionType dbStatement dbStatementCompile dbStatementDiscard dbStatementExecute dbStatementStreamingExecute dbTable dbTableClose dbTableDelete dbTableInsert dbTableOpen dbTableUpdate

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