Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using SQLExec To retrieve record from table
Message
From
13/06/1999 23:45:28
 
 
To
21/03/1999 20:12:23
Yin Min Chen
Nec Home Electronics(M) Sdn Bhd
Sungai Petani, Malaysia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00199643
Message ID:
00229346
Views:
17
Sorry for reply the letter so later,because I found the mail in the box now.
When SQLEXEC return 0 ,it happens at the "Asynchronous" mode of the connection
to SQL server. You must resend the command to the SQL.

do while .t.
ans=SQLEXEC(...)
do case
case ans<0
return "error to connect to SQL"
case ans=0
** loop for re-do the SQLEXEC(...)
otherwise
return "I got the anser from SQL"
endcase
enddo

If the connection is by synchronous mode,then the SQLserver will over the sqlexec and send the result to you,so it's better and faster to use synchronous mode in your program.
Previous
Reply
Map
View

Click here to load this message in the networking platform