At 07/14/2002 03:47 AM (Sunday), Adrian Roman wrote:

>And I know that' sometimes it happens to modifiy the same record twice in a
>single transaction. Think of an user editing a record, posting it, not
>ending the transaction, and changing it again.

Then you should test for this operation specifically. Doing two wholesale
updates of 30,000 records in one transaction is not the same as editing one
twice in a transaction. Do a realistic test.

I would be interested in: Try a wholesale update, commit the transaction,
try another one (with or without the value actually being changed to a new
value), commit the transaction. See what results you get.