Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sqlmoreresults() error
Message
De
15/06/2001 23:46:10
Del Despain
Colorado Plateau Associates
Hurricane, Utah, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00519048
Message ID:
00520237
Vues:
19
Thanks! I'll play with it and see what happens. This is actually happening with a widely used class and no one else reports any problems. Maybe its just the way I'm using it. Very frustrating.

I appreciate your help!

Del


>Hi!
>IMO it's not connection settings, but error in your program. In asynchronous mode you should check value returned from SQLMORERESULTS() and call in repeatedly until it returns non-zero value before calling other SQL pass-through function. Or call SQLCANCEL() before calling other function to break execution. Timing issues can explain different execution on laptop and desktop.
>
>>I am developing a VFP application using a SQL Server 7 backend. I am working on a desktop with SQL Server installed on the desktop. I installed SQL Server on a laptop and moved the application to the laptop. On the laptop only, I keep getting the message "Invalid call issued while executing a SQLMOREREULTS() sequence." I have played with the ODBC connection "Batchmode" and "Asynchronous" settings to no avail.
>>What other setting(s) am I missing? Any suggestions?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform