Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is VFP too fast for SQL Server
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01038128
Message ID:
01038144
Vues:
21
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform