• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
RE: MS SQL, EOF, Ordering Operations
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: MS SQL, EOF, Ordering Operations
      • From: Chuck Hill <email@hidden>
References: 
 >MS SQL, EOF, Ordering Operations (From: Chuck Hill <email@hidden>)

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