>I have the following situation for which I hope someone can lend assistance.
>
>Form1's purpose in life is to update Table1 via Updateable View1.
>
>Updateable View1 is optimistic table buffered.
>
>Immediately after the TableUpdate(.T.) has been issued to Updateable View 1, another user on another workstation attempts to query Table1 and finds that the updates are not yet committed.
>
>Committal sometimes takes minutes.
>
>This is currently causing some pretty severe problems.
>
>Any advice will be GREATLY appreciated!
I found out that if you issue...
=RLOCK()
UNLOCK
on updated tables immediately after your tableupdate, then the information is then actually "written" to the HD. Apparently, doing this bypasses any system caching/buffering.
HTH
//:^)