Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using SQLExec To retrieve record from table
Message
De
13/06/1999 23:45:28
 
 
À
21/03/1999 20:12:23
Yin Min Chen
Nec Home Electronics(M) Sdn Bhd
Sungai Petani, Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00199643
Message ID:
00229346
Vues:
18
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform