Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec Return Code
Message
From
11/06/2003 05:42:07
Jeffrey Havelock
Skipton Information Group
Leeds, United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQLExec Return Code
Miscellaneous
Thread ID:
00798798
Message ID:
00798798
Views:
63
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
Jeff Havelock
Senior Data Developer
jeff.havelock@eurodirect.co.uk
Next
Reply
Map
View

Click here to load this message in the networking platform