Re: Error with Cross-Model Relationship
Re: Error with Cross-Model Relationship
- Subject: Re: Error with Cross-Model Relationship
- From: David Avendasora <email@hidden>
- Date: Tue, 2 Dec 2008 12:41:40 -0500
The scheme is on all my tables (dbo.) The problem isn't different
Schemes, it's different Databases and on possibly different servers.
I swear I had it working at one point. I'm not sure why it isn't now,
or if I was just hallucinating in the first place.
Dave
On Dec 2, 2008, at 12:24 PM, Susanne Schneider wrote:
Hi David,
to allow EOF to make cross schemes joins for two models just add the
user (database scheme) name before the table name in the eomodel.
Set "myscheme.mytable" instead of "mytable". You only have to make
sure that the database schemes are readable vice versa (select
rights, at least for Oracle).
We do this for a long time without problems with a slightly
complicated Oracle database, where a part of the database schemes
are defined in a general part. At startup the tables of the generic
models are extended with the correct usernames.
Regards,
Susanne
--
Susanne Schneider
Coordinator secuTrial Development
iAS interActive Systems GmbH
Dieffenbachstraße 33 c, D-10967 Berlin
fon +49(0)30 22 50 50 - 498
fax +49(0)30 22 50 50 - 451
mail email@hidden
web http://www.interActive-Systems.de
----------------------------------------------------
Geschäftsführer: Dr. Marko Reschke, Thomas Fritzsche
Sitz der Gesellschaft: Berlin
Amtsgericht Berlin Charlottenburg, HRB 106103B
----------------------------------------------------
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden