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: Jonathan Rochkind <email@hidden>
- Date: Wed, 26 Feb 2003 12:30:33 -0600
At 03:57 AM 2/26/2003 +0000, 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?
It's supposed to be possible, but I've had trouble getting it to actually
work, even in WO 5.0. Haven't tried with 5.2 yet. I'm talking about a
flattened relationship accross the join table---if it's not flattened
relationship, there's nothing special about the fact that it spans dbs, and
it should most definitely work. It's the flattened ones I've had trouble with.
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.
It's possible this error is due to something else. I'd start out putting
all the tables in the same database (and the same EOModel!), and see if you
can get it to work this way. Once you've gotten it to work this way, you
know you've got everything set up properly, and then you can try moving the
table to another database and/or model. If it doens't work, you know it's a
problem with EOF not wanting to do that accross models/databases.
--Jonathan
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.