Hi Shihchau,
If you need to check if a user is already editing a record and let the current user know before editing and trying to save, you need to use the good old RLOCK and UNLOCK in the Edit method of your forms. HTH
>Basically, my users want my program to be able to inform them someone is using the record when they try to edit the record. Is there a way to do it? I am using parameterized view.
>
>
>
>>Shihchau,
>>
>>If you use optimistic buffering, the tableupdate() operation will fail if the station attempts to overwrite information.
>>
>>Marc
>>
>>
>>>In Microsoft technet Q130299, it states that CURVAL and OLDVAL will return the same value if all these are met:
>>> - Two forms in the same Visual FoxPro session are using the same table.
>>> - The data on one instance of the form has been modified.
>>> - The data on another instance of the form has not been modified.
>>>
>>>My invoice module is a formset consists of a listing form and an add/edit form. Anyone can tell me how I can allow my user to do force update when they have editing conflict? I have problem because my error handling routine's curval() and oldval() return the same value. Is there any other way of detecting a change by another network users?
>>>
>>>Any suggestion? I am using parameterized view for my add/edit form.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.