SQLPrepare Command

SQLPrepare

Obsolete

Refer to the SQLPrepare method in the cSQLStatement class.

SQLPrepare hstmt sStatement

The SQLPrepare statement will prepare a statement for execution. This will enable the DataFlex programmer to prepare once and run many times.

It is possible to pass a so-called batch of statements. Multiple statements must be separated by a semicolon (;).

Open Customer
SQLFileConnect Customer To hdbc
SQLOpen hdbc To hstmt
SQLPrepare hstmt "UPDATE CUSTOMER SET AccntMngr = 'John' WHERE AccntMngr = 'Mary'"