Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connectivity Error: Invalid cursor state
Message
 
 
To
02/04/2005 17:58:26
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01001052
Message ID:
01001053
Views:
18
>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?

WAG, try GO TOP.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform