>Hi Mark,
>
>>
>>Marc,
>> The reason your not getting the behavior you want is because your trying to lock buffered data. Even if you could lock the buffered record that doesn't mean that the record is locked in the table.
>
>That's an intersting point. I have a few applications that run quite satisfactorily and that use locks on buffered data. That being said, I think the probability of 2 users trying to update the same record is quite small in these environments. But they run for more than a year for some and I've never had any complaint (about this particuliar problem :)).
>
>Marc
Come to think to it, due to the fact that the records I lock are not through the buffering functionality (user enter data into ad hoc curors that are bound to the form controls), that's probably the reason. The records that I lock are untouched at the moment of locking.
Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.