[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

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/email@hidden

This email sent to email@hidden

Follow-Ups:
- RE: MS SQL, EOF, Ordering Operations
  - From: "Ruenagel, Frank" <email@hidden>

Prev by Date: Space still available: WebObjects I - Introductory Course, 6/18-6/22 in Seattle, WA
Next by Date: performing actions in subcomponent
Previous by thread: Space still available: WebObjects I - Introductory Course, 6/18-6/22 in Seattle, WA
Next by thread: RE: MS SQL, EOF, Ordering Operations
Index(es):
- Date
- Thread

Home