>Hi Mark,
>Thanks for the code. May I pass it on to the DBAs? (We'll see how they react. <g>) With SQL Server I use WhereType Key and TimeStamp. How do I handle UpdateConflicts with this? Key and Modified?, No because I'm not modifying the "Timestamp" in my App. How do you handle this?
>TIA,
You may use the code as you wish. There is nothing proprietary or secret about any of the Oracle code. I do not update or set values for the KeyID, Updated_By and Last_Update fields. My triggers handle this entirely. Since I do not update these fields, how Oracle handles the setting of the values for these fields has no bearing on update conflicts on other fields.
The only way an update conflict can occur, is if another user changes a value in a field other than those 3. If you decide not to issue the update and do not force the update, no field values change including those 3.
Mark McCasland
Midlothian, TX USA