• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Many To Many relationships across multiple databases [:|)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

References: 
 >Many To Many relationships across multiple databases [:|) (From: "Riaz Lalehzari" <email@hidden>)

  • Prev by Date: Re: Windows, WO5.2, Bourne shell?
  • Next by Date: Re: Many To Many relationships across multiple databases [:|)
  • Previous by thread: Many To Many relationships across multiple databases [:|)
  • Next by thread: Re: Many To Many relationships across multiple databases [:|)
  • Index(es):
    • Date
    • Thread