Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor Adapter Load Issue
Message
 
 
To
13/07/2005 12:32:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01032293
Message ID:
01032330
Views:
15
Are your MaxRecords and FetchSize properties of the CAs set to -1? If not, try those settings instead.

>I am altering an existing application to use cursor adapters to retrieve data from a SQL Server. My connection works and I receive a data handle and I can fill my cursor adapters no problem either. The issue I have begins when I have several cursor adapters in the data environment of a single form. Then, in some of the forms, not all, only one of the cursor adapters will load and no error will be returned. However, if a step through the init of the cursor adapters starting in the beforetableload event they all will open. This suggests a speed / retrieval issue, but I checked the asyncronous setting on my connection handle, etc. and the issue still persists. Does anyone have any ideas?
>Thanks in Advance,
>Ian
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform