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