Re: MS SQL Server and Deferred Constraints
Re: MS SQL Server and Deferred Constraints
- Subject: Re: MS SQL Server and Deferred Constraints
- From: Chuck Hill <email@hidden>
- Date: Wed, 27 Jun 2007 13:34:47 -0700
On Jun 27, 2007, at 1:08 PM, David Avendasora wrote:
You rock Chuck!
Is adding Wonder to my project the only way to do this?
Yes, but. Nothing in these classes rely on any Wonder "magic". Just
link in the framework (it does nothing by default) and use the
classes. I just put them in Wonder as it is a handy place to share
things.
You know, you're going to drag me kicking and screaming into the
new millennium. What's next Eclipse?
I can dream... :-P
Oh, and is that the name of the Class? I didn't realize you could
put spaces in there. Shouldn't it be "MSSQLsuxOr"? ;)
LOL
Chuck
On Jun 27, 2007, at 2:51 PM, Chuck Hill wrote:
Hi David,
I am just cleaning up code to handle this and also ordering the
DROP TABLE statements for MSSQL. It should be in Wonder in a few
hours.
MSSQL suxOr.
Chuck
On Jun 27, 2007, at 12:43 PM, David Avendasora wrote:
I know this issue has been discussed before, or at least eluded
to in posts, but I'm having problems with EOF inserting records
into related tables before it inserts them into the primary table
(I end up with Foreign key constraint SQL errors).
I'm using MS SQL Server (I know, but it is a requirement for the
application) and I need to have some way of making sure when
EOEditingContext.saveChanges() executes, it saves the records
bound for the primary table first. Here's my structure:
Routing<->>RoutingStep<->>RoutingComponent
Records for three are being instantiated in one EOEditingContext,
but when I call saveChanges() on it, sometimes (but not always)
it errors because it tries to insert RoutingComponent prior to
RoutingStep or RoutingStep prior to Routing into the database.
the end of the transaction. What is the most effective way to
work around this? I'm sure it has been addressed by people before
and if I'm just not finding it (I googled it). If it's out there,
just paste a link, if not, can someone share a code sample of how
they deal with it?
--
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
--
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