Home » Developer & Programmer » Forms » Update sequence
Update sequence [message #81458] Thu, 20 February 2003 03:14 Go to next message
Denver
Messages: 1
Registered: February 2003
Junior Member
A trigger for an update will perform a delete and insert of the specified record. What is the sequence: (a)Insert then delete
or
(b)delete then insert.
My delima:
(a) would imply a duplicate record with a duplicate primary key.
(b) would imply that rollback rules are broken.
Re: Update sequence [message #81459 is a reply to message #81458] Thu, 20 February 2003 04:10 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member

a- will result to error [[primary key constraint]]
b- will work:
dont commit after deleting the record
first delete then insert then commit
if things go wrong before commit, rollback will restore the first deleted record and thus rules are not broken.
Previous Topic: Form 9i is not working
Next Topic: How to set the Database Item Property dynamically...
Goto Forum:
  


Current Time: Fri Dec 03 13:53:26 CST 2021