Hello!
There is an answer to your question. Simply use two function: SqlPrepare()
and SQLEXEC(). Be sure that your SPT is configured as asynchronous. All
what
you must do (simple example from help):
... there open your SQL connection and prepare your variables
gcAuthor = 'Smith'
= SQLPREPARE(gnConnHandle, 'SELECT * FROM authors;
WHERE au_lname = ?gcAuthor','ResultSet')
do while .t.
lnSQLRetCode = SQLEXEC(gnConnHandle)
if lnSQLRetCode <> 0
exit && SPT return something different than zero
endif
enndo
... processing cursor ResultSet or trap the error from SPT
Yours ever,
Vladimir Shevchenko
> I don't know what to do when SQLEXEC() returns 0 indicating that the SQL
> pass through command has not yet finished executing.
>
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer