Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is VFP too fast for SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01038128
Message ID:
01038150
Views:
17
Well, that didn't work. I put the GO BOTTOM after the CursorFill. I still get the "alias is not found" error. Stepping through continues to make it work just fine. Any other suggestions would be appreciated.

>>I'm converting a program to use SQL Server on the back end and I've written a test program to ensure that I can talk to SQL Server, fill cursors, make changes, and save the changes to the back end. The program opens the tables, populates some cursors and does some tableupdates. If I just let it run, it gets to one point and says the cursor does not exist, but if I step through it, it works fine. I can reproduce this at will. So it's like VFP is too fast for SQL Server. It's expecting the cursor to be filled, but it isn't. Will I have to put delays in this program to let SQL Server finish its job? Anyone seen this before?
>>
>
>Add a go bott statement for all your cursors your returning from the server. You think your getting alot of data, VFP does, but it's not.
>
>That should fix it.
>
>Oh and are you pulling entire tables from the back end? If so, STOP THAT. This is now client server and no longer xBase.
eCost.com continues to rip people off
Check their rating at ResellerRatings.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform