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:
01038150
Vues:
16
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform