Re: Error with Cross-Model Relationship
Re: Error with Cross-Model Relationship
- Subject: Re: Error with Cross-Model Relationship
- From: Susanne Schneider <email@hidden>
- Date: Tue, 02 Dec 2008 19:05:54 +0100
Sorry, I read your description not careful enough.
I suppose it is not possible to add the database to the tablename too,
like "mydatabase.myscheme.mytable"?
Good luck!
Susanne
David Avendasora schrieb:
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
--
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