Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connectivity Error: Invalid cursor state
Message
De
02/04/2005 17:58:26
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Connectivity Error: Invalid cursor state
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01001052
Message ID:
01001052
Vues:
88
A form uses a remote view into a SQL Server database. One of the fields is Varchar 8000 bytes which comes over as memo field. As the form is opened and the contents of the field are accessed in the corresponding editbox init, there is a message Connectivity Error: [Microsoft][ODBC Driver Manager] Invalid cursor state. I placed a set step on in the editbox init, and voila, no error appears.

Suspecting a timing problem I added a delay. This solves the problem but requires about a 7 second delay. Is there a way to have VFP make the first record available immediately and continue fetching in the background?

TIA, Alex
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform