|
|
|
|
|
|
|
|
|
|
version 1.5
Low level commands use SQL statements to manage the communication between 4th Dimension and Oracle. Using 4D for Oracle's low level commands, you can perform any operation accomplished using context commands. You can load rows from the Oracle server, add and modify data, and so on.
Unlike context commands, however, low level commands require you to construct valid SQL queries. For example, you can use the following statement to insert a row into the EMP table:
err:=OD Set SQL in cursor (Cursor_ID;"INSERT INTO EMP VALUES (John, Black)")
To execute the statement on the Oracle server, 4D for Oracle uses Oracle Call Interfaces (OCIs) to translate the low level statement into a statement that Oracle can understand. For every low level command in 4D for Oracle, there is a corresponding Oracle Call Interface.
The section OCI—4D For Oracle Equivalents lists the low level 4D for Oracle commands and their Oracle Call Interface equivalents.
|
|
|
|
|
|
|
|
|
|