prevent 2 users updating same row

hi, i have the following situation where user A and B select the same row...then A updates and commits....then B update commits.. problem is user B overlays user A updates....i need to prevent this.

the select for update only locks other users from updating...not reading any ideas?

here's my sql..

user A: select * from miketable where user= 100;
user B: select * from miketable where user=100;
user A: Update miketable where user=100;
        commit;
user B: update miketable where user=100;
        commit;

thanks
mike

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 02 2000 - 14:08:18 CDT