Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sqlmoreresults() error
Message
 
To
13/06/2001 16:19:06
Del Despain
Colorado Plateau Associates
Hurricane, Utah, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00519048
Message ID:
00519852
Views:
12
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
Next
Reply
Map
View

Click here to load this message in the networking platform