Re: MS SQL, EOF, Ordering Operations
Re: MS SQL, EOF, Ordering Operations
- Subject: Re: MS SQL, EOF, Ordering Operations
- From: Chuck Hill <email@hidden>
- Date: Mon, 28 May 2007 10:48:41 -0700
On May 26, 2007, at 4:51 AM, Ruenagel, Frank wrote:
Hi Chuck,
it happens :-(. We use a delegate to order the inserts if needed.
Thanks, I was afraid that would be the answer. :-(
In SQL-Server 2005 there is a "WITH ( IGNORE_CONSTRAINTS )" table
hint, but I never tried it.
http://msdn2.microsoft.com/en-us/library/ms187373.aspx
I looked at that but it seems that it is for batch operations only.
It also totally ignores the constraints ("this can result in invalid
data"), rather than just deferring them.
So, I am writing a delegate.
Chuck
-----Original Message-----
From: webobjects-dev-bounces+webobjects=email@hidden
[mailto:webobjects-dev-bounces+webobjects=symposion.de@lists.a
pple.com]O
n Behalf Of Chuck Hill
Sent: Friday, May 25, 2007 10:29 PM
To: WebObjects-Dev Mailing List
Subject: MS SQL, EOF, Ordering Operations
Hi All,
I am working on supporting MS SQL2005 for an application that runs
under FrontBase now. One thing I stumbled upon is that MSSQL does
not support constraints that are DEFERRABLE INITIALLY DEFERRED. I
always use this for my FK constraints so that the sometimes random
ordering of statements by EOF does not cause FK constraint
violations. What do you MSSQL users do? Does this not happen? Do
you use a delegate to manually order them?
Anything else to watch out for on a database that does not yet
implement a 15 year old standard?
Thanks!
Chuck
--
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:
email@hidden
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
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