>>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