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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > 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 protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/webobjec > ts%40symposion.de > > This email sent to [EMAIL PROTECTED] > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
