Hi Chuck
is this MSSQL Server only or will this work for frontbase as well?
i've always had to handle fk constraints in frontbase manually on
cascade delete's, across tables.
regards
cornelius
On Nov 21, 2007, at 7:54 PM, Chuck Hill wrote:
Not! Well, not exactly. The work just fine with two notable
exceptions:
1. If you are using a super fine SQL database (and I use the term
database loosely here) like MS SQL Server from a vendor who still
rails against constraint handling ("It's wrong! We're right!")
accepted as a standard (see SQL92) for the last 15 years or who just
can't get it together to implement deferrable constraint handling,
well, then FK constraints might not work so well. Unless... you use
Project Wonder* and include this line in your main() method:
ERXDatabaseContextMulticastingDelegate.addDefaultDelegate(new
ERXEntityDependencyOrderingDelegate());
2. You have a really stupid legacy schema or like pain a lot and use
Horizontal Inheritance (which IIRC even the EOF masochist LD does
not use... yet), in which case FK constraints are impossible to
enforce at the database level.
Chuck
* Project Wonder fixes almost everything except World Peace.
On Nov 21, 2007, at 10:24 AM, Mike Schrag wrote:
FK constraints work just fine ...
ms
On Nov 21, 2007, at 10:56 AM, Jeffrey Simpson wrote:
I have been told that when using EOModeler you cannot have Foreign
Key
Constraints. Is this true? Does anyone use them?
Jeffrey Simpson
Youth For Understanding USA
Preparing young people for their responsibilities and
opportunities in a
changing, interdependent world.
_______________________________________________
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/mschrag%40mdimension.com
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/chill%40global-village.net
This email sent to [EMAIL PROTECTED]
--
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/cjaeger%40visualfood.ch
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]
