Re: Many To Many relationships across multiple databases [:|)
Re: Many To Many relationships across multiple databases [:|)
- Subject: Re: Many To Many relationships across multiple databases [:|)
- From: Max Muller <email@hidden>
- Date: Wed, 26 Feb 2003 09:18:06 -0800
Hi Riaz,
Many-To-Many across databases is possible (although there was a bug in
4.5 that prevented this for flattened relationships or for using
physically different databases, ie mixing Oracle and the FlatFile
adaptor). I haven't tried this in WO 5+. The error you are getting is
generating the foreign key constraint. If you are using different
databases then it is not possible (that I know of) to have a database
enforce foreign key constraints on a different database. I would just
not execute that part of the table creation. Also note that you will
need to use different EOModels for every database you use, so your M-M
relationship will need to be a cross model relationship.
Regards,
Max
On Tuesday, February 25, 2003, at 07:57 PM, Riaz Lalehzari wrote:
I have the the standard tables for a many to many relationship. Eg.
'Driver', 'Car', 'Car-Driver-Join'.
Is it possible to have for example 'Driver' and the Join table on one
database and the 'Car' on the other? Because there is an existing db
which I prefer not to modify and this situation has happened. Whenever
I add the cross database many to many relationship, and press 'SQL' to
generate the sql. It always gives an error when it gets to the part
specifying the foreign keys and so on. (ALTER...)
I'm using sqlserver.
Thanks,
Riaz
-------------------
_________________________________________________________________
Hotmail now available on Australian mobile phones. Go to
http://ninemsn.com.au/mobilecentral/hotmail_mobile.asp
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.