Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to fix connection is busy error
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00977596
Message ID:
00977670
Views:
35
>I want to edit remote view in grid, saving changes for each record.
>Remote view returns large number of records so I use asynchronous fetching.
>
>However, if record needs to be updated, "Connection is busy" error occurs.
>
>I tried to set view MaxRecords property to 100, but does not allow to retrieve next 100 records.
>
>How to fix this issue ?
>
>Is it possible to fetch more that MaxRecords records in remote view ?
>Is it possible to update view using another connection ?
>Is there any other solution ?
>Any idea or code sample ?

You could try playing with the FetchSize and FetchAsNeeded properties. One thing that I've found that works in this case is a GOTO BOTTOM before any other commands. Of course, that could take a while on a really large table.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform