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:
01038496
Vues:
14
Make sure the variable holding the CursorAdapter object is visible wherever you access the data from the cursor. For example if you are parsing a previously filled ADO Recordset to a VFP cursor with:
*  Form Init
     Local loCAExample

     loCAExample = CreateObject("CursorAdapter")
     loCAExample.DataSourceType=[ADO]
     loCAExample.Alias=[MyCursor]
     loCAExample.CursorFill(,,,myADORS)
  Return 
Then referencing "myCursor" in any other procedure than the form Init's will generate the error you mentioned.

HTH,

Enmanuel

>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?
>
>Russell Campbell
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform