EvaluateExpression fails for a Derived Column
EvaluateExpression fails for a Derived Column
- Subject: EvaluateExpression fails for a Derived Column
- From: Baiss Eric Magnusson <email@hidden>
- Date: Wed, 26 Sep 2007 19:07:28 -0700
I added a <Derived Column> to a table with the following <Read Format>
(SELECT COUNT(*) FROM EVENT_TABLE WHERE EVENT_TABLE.EVENT_ID =
FRIENDS_EVENT.EVENT_ID)
It fails, and from <Data Browser> I see
JDBCAdaptorException: EvaluateExpression failed: <FrontbasePlugIn
$FrontbaseExpression:
"SELECT (SELECT COUNT(*) FROM EVENT_TABLE WHERE EVENT_TABLE.EVENT_ID
= FRIENDS_EVENT.EVENT_ID)
FROM "EVENT_TABLE" t0">:
Next exception:SQL State:00 subclass = " -- error code: 226 --
msg: Semantic error 226. Referenced column - EVENT_ID - not found.
Now both EVENT_TABLE and the many-to-many join table FRIENDS_EVENT
have an EVENT_ID field, so what is wrong?
BTW: this is taken from page 183 of Ravi Mendis' book and I believe
it is the correct solution to my previous question of how to create a
Fetch Specification where one of its conditions is
to check for an NSArray length of greater than zero.
----
Baiss Eric Magnusson
<http://www.Track-Your-Finances.com>
<http://www.CascadeWebDesign.com>
_______________________________________________
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