Hi!

You can have another remote view with only one requird in it. When you start to edit some record, query that record inthat another remote view in another connection using the parameter (record ID) for second view. Then update data through that view instead.

You're right, it is not possible to update data on teh same connection till all records fetched (downloaded) from server.



>Hi Vlad,
>I have already tested the Fetch As Needed option for remote views.
>It is good for enquiry records but not for update records. Because
>an "Update Conflict" error will occur when I issue TableUpdate(.t.)
>command as the remote view is fetching records in the background.
>I can only update until the fetch process endded. So it seems not
>possible for large tables. I wonder if I can update the view during
>fetching records. This will reduce many steps in coding.
>Anyway, thank for your suggestion.