Re: Error with Cross-Model Relationship
Re: Error with Cross-Model Relationship
- Subject: Re: Error with Cross-Model Relationship
- From: Travis Britt <email@hidden>
- Date: Tue, 2 Dec 2008 07:00:41 -0500
Are you sure you've done qualifiers that cross DBs and had it work?
tb
On Dec 2, 2008, at 5:20 AM, David Avendasora wrote:
I have am having a problem with a cross-model relationship. Here's
the relationship
LotCode <->> ExternalLotCode
LotCode is in one EOModel and ExternalLotCode is in another. The
EOModels are for two different databases, which may or may not be
running on the same DB server. I've tested it both ways and have the
same problems.
When I search for ExternalLotCodes by specifying values for
attributes that exist on LotCode, I get an Invalid object name
'dbo.Lot_Code' error, which is the right table name, but it is
looking in the wrong DB for it. The FROM clause of the SQL sent to
the DB (ROM dbo.MSDynamics_Lot_Code t0, dbo.Lot_Code T1 ) shows that
it is trying to create a join between tables in different DBs which
is not going to work.
I've done other cross-db relationships that have worked. Why isn't
this one? Any guesses?
_______________________________________________
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