>>>>I've created a local view in my database for use in a grid for displaying and updating native VFP tables.
>>>>
>>>>The problem I'm having with a local view is that if user1 modifies a record on the view, and user2 tries to modify the same record, I cannot trap the error instantaneously for user2 (as I would if I were using native base tables). Is there a way to apply the normal base table locking scenarios to local views?
>>>
>>>Are you sure it is necessary? In other words, is it likely that two people will edit the same record at the same time?
>>
>>I don't know, I'm just trying to build in some safeguards.
>
>The way I have used views is to optimistically buffer the records, then issue a tableupdate. Usually, the original data was not changed. However, if it has been changed, give the user the option of writing over the changes someone else made, or discarding the changes.


Thanks. I guess the code I'm missing is to requery the view everytime I issue a tableupdate to ensure the data not been changed, then give the user an option as you mentioned.