Re: Transactions & locking

>After "Begin Work", all rows touched will be locked. However, does this >locking happen to all affected rows at the start, or as they are affected? > > The row will be locked when it is altered. Probably the best way to prevent the deadlocks from occuring is to try to ensure that the updates are occuring in the same order. One other choice would be to issue a lock table so that the process would be single threaded. - Not a really good solution, but possible. Madison Pruet