Re: Out of order SQL statements?

Thu, 23 Feb 2006 13:33:34 -0800

Although it's a bit of work, you could become the delegate to the adaptor and order the operations yourself.  I wrote some code a while back that ordered operations in a way that would make sure key requirements were met, and that parents weren't deleted before children.  Sorry, don't have it anymore.

On Feb 23, 2006, at 4:06 PM, John Huss wrote:

I've got a Master-Detail edit page where the user can add and delete detail records.  One of the detail fields has a UNIQUE constraint on it. 
 
If I delete a detail record and then add a new one with the same unique key and save, it causes a constraint violation in the database.  Looking at the generated SQL, it is executing the INSERT before the DELETE, even though the delete happened first.  Why is this happening?
 
John
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:

This email sent to [EMAIL PROTECTED]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to