Cross-Database Qualifier FetchSpec
Cross-Database Qualifier FetchSpec
- Subject: Cross-Database Qualifier FetchSpec
- From: King Chung Huang <email@hidden>
- Date: Wed, 02 Jul 2003 09:43:26 -0600
Hi,
Say I have a relationship from TableA to TableB called "metadata", with both
tables in different databases, and make an EOKeyValueQualifier with
key:"metadata.anAttribute" (ie: qualified on an attribute in TableB). Is
there any way EOF can handle the qualification/fetch correctly? At the
moment, it generates the following SQL:
SELECT t0."AN_ATTRIBUTE", t0."ROW_ID" FROM "TABLEA" t0, "TABLEB" T1 WHERE
T1."AN_ATTRIBUTE" = 'Metadata #1' AND t0."ROW_ID" = T1."OBJ_ID"
Which results in the following error:
Semantic error 116. Referenced TABLE - TABLEB - does not exist.
This is pretty obvious since TABLEB doesn't exist in the same database as
TABLEA. So, is there some way of getting EOF to break down the operation
into multiple steps to get what I want? Or, is using a cross-database
qualifier a no-no in EOF?
Any help or advice is appreciated!
Thanks,
King Chung Huang
Learning Commons
University of Calgary
_______________________________________________
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.