MS SQL, EOF, Ordering Operations
MS SQL, EOF, Ordering Operations
- Subject: MS SQL, EOF, Ordering Operations
- From: Chuck Hill <email@hidden>
- Date: Fri, 25 May 2007 13:29:04 -0700
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:
This email sent to email@hidden