|
|||||
|
||||||
Other Library Functions |
function |
dbExecute |
Library: Database access (OMDB legacy)
Include: omdb.xin |
define external function dbExecute value dbDatabase database SQL value string statement
Argument definitions
Use dbExecute to execute a single SQL statement on the specified database.
You must include the following line at the beginning of your OmniMark program:
include "omdb.xin"
The dbDatabase object database must be:
The stream variable statement must not be empty (else external exception OMDB105).
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 (cid, CourseName) " || "values ('456', 'Four-on-the-Floor Gearshifting')" } set my-database to dbOpenODBC "dbDemo" dbExecute my-database sql SQL-insert
Copyright © Stilo International plc, 1988-2010.