G
gus
Guest
Experience is what you get when you don't get what you want. Even without considering the possibility of duplicate rowids, that code might not work the way you want because after the first find, but before the second, the following could happen: a second transaction comes and deletes the customer you found and then commits. a third transaction comes along and creates a new record with the same rowid as before and commits. if the new record is for a different table, then the find customerupdate will not find it. if the new record is for the same table, then the find will succeed but the record will be the new one, not the one you found before.
Continue reading...
Continue reading...