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:
00977832
Views:
39
>>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.

I tried those properties but without success.
It seems that it not possible to cause REMOTE view to fetch more rows without
connection is busy error.

I also thied to increase MaxRecords property in runtime
DBSetProp('RKLIENT', 'View', 'MaxRecords', DBgetProp('RKLIENT', 'View', 'MaxRecords')+100)
and use REFRESH() function but this does not work without requery.

Fetching rows on demand is only possible using async fetching but this makes connection busy.
Andrus
Previous
Reply
Map
View

Click here to load this message in the networking platform