What about a FLUSH after you commit the changes? What OS are the workstations? Check the write cache settings on them--I ran into that problem once!
Tracy
>I have a commercial app developed in VFP 6.0 and Visual Maxframe. I have many clients that complain of records input on one workstation don't show on the other workstations for a delayed period of time.
>
>I have done a lot of research on this and have come to the conclusion that I need to change my base form classes to issue an rlock() on all open tables. Is this a correct conclusion? Is anyone else doing this?
>
>I was wondering where would be the best place to put this code. Would it be in the init of my base form class?
>
>Any better solutions?
>
>TIA
>Paul Acton
.·*´¨)
.·`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"