dbTableOpen

function

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

Returns: a specific table of type dbTable

Declaration

define external dbTable function dbTableOpen
       value    dbDatabase  database
 table value    stream      table

Argument definitions

database: is a dbDatabase object representing an open database connection.

table: is the name of the table in the database you wish to access.

Purpose

Use dbTableOpen to attach a dbTable OMX item to an existing table in the database.

Requirements

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

  include "omdb.xin"

The database connection represented by database must be:

open (else external exception OMDB209)
in scope (else external exception OMDB103)

The table must exist (else external exception OMDB501).

Usage Notes

You may open a table that is already opened. The resulting dbTable object behaves independently, unlike a copy.

Example

This code sample shows two different ways of opening a table. The choice depends on whether you want to reuse the table connection or not.

  include "omdb.xin"
  
  process
      local dbDatabase this-db
      local dbTable course
      local dbTable course-2
      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'
      dbExecute this-db SQL SQL-insert
  
      dbTableInsert dbTableOpen this-db table 'Course' from course-data