Re: Out of order SQL statements?
Re: Out of order SQL statements?
- Subject: Re: Out of order SQL statements?
- From: Chuck Hill <email@hidden>
- Date: Thu, 23 Feb 2006 13:18:04 -0800
On Feb 23, 2006, at 1:11 PM, Sacha Michel Mallais wrote:
On Feb 23, 2006, at 1: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?
What database are you using? Some databases can defer asserting
the constraints until commit. That's probably what you want.
Alternatively, there is a WO api that allows you to manually order
the SQL operations.
Best to create the constraints as DEFERRABLE INITIALLY DEFERRED when
you create the table. Barring that there should be a class to order
these on www.wocode.com, or if not there, Project Wonder must have one.
Chuck
--
Coming in 2006 - an introduction to web applications using WebObjects
and Xcode http://www.global-village.net/wointro
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems. http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden