On 21 Nov 2007, at 16:56, Jeffrey Simpson wrote:
I have been told that when using EOModeler you cannot have Foreign Key Constraints. Is this true? Does anyone use them?
We use them with Oracle. I think it depends on the database you use. You need to make sure that the constraints are not applied immediately. If you commit several operations with EOF, you don't know what order they will be applied in and the constraints can break things. With Oracle this can be achieved by making sure that your constraints are applied with 'INITIALLY DEFERRED DEFERRABLE'. Be careful with cascade deletes though, because EOF snapshots do not like having objects deleted from underneath them.
-- James _______________________________________________ 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]
