Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sqlmoreresults() error
Message
From
15/06/2001 23:46:10
Del Despain
Colorado Plateau Associates
Hurricane, Utah, United States
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00519048
Message ID:
00520237
Views:
18
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?
Previous
Reply
Map
View

Click here to load this message in the networking platform