SQL code -246, ISAM code -154 problem.

Running OnLine V5.0 under AIX. We have a begin/commit process that locks a parent record by updating a column with its current contents. We find that if two users try to update different rows in the same child table, the first will suceed and the other fail with SQL code -246, ISAM code -154. The two users are accessing different rows in both the parent and the child tables. This only happens if the first user has not reached the 'commit' before the second user trys to update. Both the tables have row mode locking set. 1st User User 2 begin work begin work lock parent row x lock parent row y . . . . update child row m . . update child row n (fails) . . . . commit . update child row n (OK) . commit Peter Jennings.