I agree with Hilmar on recommending optimistic buffering. However, if you want your users to know everytime someone is editing a specific record so no two users attempt to edit the same record at the same time, then pessimistic works well. I had that requirement when I worked for the government - the entire app used pessimistic for that very reason. They had a requirement that no two workstations could edit the same record at the same time so the record had to be locked on editing instead of on the save like optimistic.
>Sorry, I didn't phrase that response very well.
>
>Your first response hit the nail on the head. When I set exclusive off, everything worked properly.
>
>Now that exclusive is off and the data is being shared, I was asking your opinion of what the best way was to buffer the data.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
