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 13:25:32 -0500
It may be possible. That syntax is recognized by MS SQLServer. I could
even specify
server.database.scheme.tableName... I don't know if that would help or
not. I'll try it later.
Dave
On Dec 2, 2008, at 1:05 PM, Susanne Schneider wrote:
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