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.

Related Topics