Hi Andrus
This is feature...
If connection is using (Asynchronous connection, fetching auto/handshake) you cannot use connection for another operations (TABLEUPDATE(), SQLEXEC(), SQLMORERESULT(), etc.)
You can call SQLCANCEL() for connection. VFP stop execution SQL command on conection.
1) No
2) Yes, open View or can use SQLEXEC() with new opened connection
3) Yes, use synchronous connection if possible.
MartinJ
>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 ?