Hi All,
I am processing a SQLExec statement which executes a stored procedure. Using code similar to that below, should I expect the initial returned value of 0 (processing) to change to 1 (finished) 10 minutes later when the procedure completes ...
ThisForm.nSQLResult=SQLEXEC(ThisForm.nConnHandle, "EXECUTE MyStoredProc")
The connection is set to asynchronous. Currently the value of nSQLResult is not updating once the procedure has completed, so any validation code never triggers.
Any help appreciated.
Jeff