RE: MS SQL, EOF, Ordering Operations
RE: MS SQL, EOF, Ordering Operations
- Subject: RE: MS SQL, EOF, Ordering Operations
- From: "Ruenagel, Frank" <email@hidden>
- Date: Sat, 26 May 2007 13:51:26 +0200
- Thread-topic: MS SQL, EOF, Ordering Operations
Hi Chuck,
it happens :-(. We use a delegate to order the inserts if needed.
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
Regards
Frank
> -----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:
This email sent to email@hidden