Library: Database access (OMDB legacy)
define external function dbStatementExecute value dbStatement statement with read-only stream values optional null value stream null optional record modifiable dbField record optional
Use dbStatementExecute to execute a compiled SQL statement that was produced by the dbStatementCompile function.
You must include the following line at the beginning of your OmniMark program:
The dbDatabase object supplied when the statement was compiled must be open (else external exception OMDB101).
The dbStatement object statement must be open (else external exception OMDB701).
If the dbStatement object is a compiled query, it requires the dbField shelf argument record to receive the results (else external exception OMDB704).
The input shelf values must:
dbStatementExecute allows you to execute a compiled statement and to specify all the parameter values at once. This is more efficient for small parameters.
For large parameters (for example, DB_BLOB types) when there is a large amount of data to be inserted, it is more efficient to use the dbStatementStreamingExecute function, as that avoids creating an entire copy of the data in memory prior to execution.
dbStatementCompile for additional notes and examples.