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:
01038144
Views:
20
Whoa there, Stephen! Why jump to the conclusion that I'm pulling down an entire table? I'm not, don't worry. (Well I may have been in this one little test - I'm not looking at the code right now - but the backend table only has a couple of records or so - that's definitely not something I'm doing normally.)

I'll try the GO BOTTOM and see what happens. Feel free to take a stab at the other question I posted in the same Client/Server category. Thanks for the reply and I must say that I like your last name.

Russell

>>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
Reply
Map
View

Click here to load this message in the networking platform