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

Declaration

  define external function dbTableInsert
          value     dbTable  table
    from  read-only stream   values
    null  value     stream   null      optional

Argument definitions

table

is an open dbTable object.

values

is a stream shelf containing the values to insert.

null

is an optional string to represent a NULL value rather than the default unattached stream.

Use dbTableInsert to insert a record into a table using the data values in a stream shelf.

Requirements

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

  include "omdb.xin"

The database connection containing the table must be:

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

The table must :

• exist (else external exception OMDB501)
• be open (else external exception OMDB601)

The record being inserted (values) must:

• contain data (else external exception OMDB606)
• contain valid data for the table (else external exception OMDB501)
• have item keys that match table column names (else external exception OMDB603)

Usage Notes

NULL data values may be represented as unattached streams or as an optionally defined string. The column name is identified as the key of each shelf item in the values argument.

If the record has a date, time, or timestamp field, you must represent the field's value in the OmniMark Date and Time library format. (This format returns the time with a time zone offset from UTC time, which most databases do not provide.)

Example

The following program adds two new courses to a curriculum. The table records can be added using two different methods. The first is to execute an SQL statement on the database. The second approach is to use the dbTable OMX component.

  process

      ; local variables
      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'
      }
      ;  create the database OMX objects
      set this-db to dbOpenODBC 'dbDemo'
      set course to dbTableOpen this-db table 'Course'

      ; add record to the table (Method #1)
      dbExecute this-db sql SQL-insert

      ; add record to the table (Method #2)
      dbTableInsert course from course-data

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 ]