hi, I would like to tell you that lock in share mode is a Read lock not Write lock
and use Select .... For Update to write lock. Hope that will fix ur problem.
all the best.
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --