Re: SQL code -246, ISAM code -154 problem.

Peter Jennings wrote: > 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. this sounds exactly like row locking isn't used, which was my first thought, as tables default to page level locking. if you do have row locking set, (and remember, you must either set row level locking when the table is created, or change it with the alter table statment... just making sure.), then this might be a bug. but the 246 error is referring to an index problem, so you might want to start with that, checking to see that the index is ok. it sounds like it might be a bug, but would take some more investigation. have you tried SET LOCK MODE TO WAIT? see what results you get from this, even if it isn't satisfactory for one of the process' to wait. this might take care of things, as the 154 is a deadlock error. not much here, but i hope it helps, or is a start. mickm