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
• Delivered-to: email@hidden
• Delivered-to: email@hidden

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

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:
http://lists.apple.com/mailman/options/webobjects-dev/webobjec
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:
http://lists.apple.com/mailman/options/webobjects-dev/chill% 40global-village.net

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:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

• Follow-Ups:
  • Re: MS SQL, EOF, Ordering Operations
    • From: Sacha Michel Mallais <email@hidden>

• Prev by Date: Re: Slow Batch Utility
• Next by Date: Re: MS SQL, EOF, Ordering Operations
• Previous by thread: RE: MS SQL, EOF, Ordering Operations
• Next by thread: Re: MS SQL, EOF, Ordering Operations
• Index(es):
  • Date
  • Thread