Out of order SQL statements?
Out of order SQL statements?
- Subject: Out of order SQL statements?
- From: "John Huss" <email@hidden>
- Date: Thu, 23 Feb 2006 15:06:05 -0600
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden