Cached updates and multi-user

I have a real basic question.

Two users read the same record using a TQuery with CachedUpdates := TRUE

The first user changes something, and ApplyUpdates to the database. The
change is reflexed in the database.

Now the second user changes the same record, and  applies the change.

The second change is over riding the first change which I think is
incorrect.  I think that the first user's change should be the one that the
system should keep.  The second user should be forced to re-read the

How can this be done?  I'm using Oracle8 as my backend with BDE5.01 with
Delphi2 client server.

John Seitz