|
||||||||||
|
||||||||||
Other Library Functions |
function | dbExecute |
Library: omdb - high level database access
Include: omdb.xin |
define external function dbExecute value dbDatabase database SQL value stream statement
Where:
database
statement
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
---- |