Q Sql
Execute SQL statement.
Modes
-
Mode 0—sends a statement in the native DML to the DBMS. If the statement selects data from the database, this mode passes the first field of the last row of the result table to Uniface.
-
Mode 2—sends a statement in the native DML to the DBMS. If the statement selects data from the database (for example, SELECT in SQL), this formats the result table according to a Uniface convention. This mode passes the first set of result rows to Uniface.
-
Mode 3—passes a subsequent set of result rows to Uniface.
Conditions
None.
Description
This request sends DML statements to the DBMS and is not only for SQL. It is used with
the SQL Edit form, for example, and the sql
ProcScript statement. Not supported for all
DBMSs.