swirl Guide to OmniMark 5   OmniMark home
docs home 
IndexConceptsTasksSyntaxLibrariesOMX VariablesErrors
 
      Other Library Functions  
function   dbExecute    

Library: omdb - high level database access
Include: omdb.xin

Declaration

  define external function dbExecute
           value dbDatabase  database
     SQL   value stream      statement

Where:
database


statement

Purpose

The dbExecute function executes a single SQL statement on the specified database. The SQL statement may modify the structure of the database or manipulate the data in the tables. It may be any non-select type of SQL statement.

This function makes use of the dbDatabase OMX variable used to create the connection to the database. For example:

        include "omdb.xin"

        process
           local dbDatabase my-database

           local stream SQL-insert initial
              { "insert into Course values" ||
                "( '503', 'Intro to Social Theory' )"
              }

           set my-database to dbOpenODBC "DatabaseDemo"

           dbExecute my-database sql SQL-insert

        Other Library Functions
   dbClose
   dbExecute
   dbFieldValue
   dbIsVersionCompatible
   dbLibraryVersion
   dbOpenODBC
   dbQuery
   dbRecordExists
   dbRecordMove
   dbTableClose
   dbTableDelete
   dbTableInsert
   dbTableOpen
   dbTableUpdate
 
----  

Top [ INDEX ] [ CONCEPTS ] [ TASKS ] [ SYNTAX ] [ LIBRARIES ] [ OMX ] [ OMX ] [ ERRORS ]

Generated: August 11, 2000 at 3:07:05 pm
If you have any comments about this section of the documentation, send email to docerrors@omnimark.com

Copyright © OmniMark Technologies Corporation, 1988-2000.