Re: EvaluateExpression fails for a Derived Column
Re: EvaluateExpression fails for a Derived Column
- Subject: Re: EvaluateExpression fails for a Derived Column
- From: Chuck Hill <email@hidden>
- Date: Wed, 26 Sep 2007 20:10:08 -0700
This seems more like a WO question than a FB one, so I will reply here.
I'd take a look at the qualifiers in Wonder or one of Pierre
Bernard's (how many times have I typed this in the last few weeks?).
http://www.bernard-web.com/pierre/webobjects/code.html
/**
* <p>Qualifier to check for the presence of objects matching a
given qualifier in a to-many relationship.</p>
*
* <p>An object matches the qualifier if the to-many relationship
identified by at keyPath contains at least one
* object matching the nested qualifier as passed to the
constructor.</p>
*
* <p>This qualifier actually os of most interest when nested within
an EONotQalifier. This allows for verifying
* that a relationship does not contain any object matching a given
qualifier.</p>
...
*
* @author Pierre Bernard http://homepage.mac.com/i_love_my/
webobjects.html
*/
public class ExistsInRelationshipQualifier
Chuck
On Sep 26, 2007, at 7:07 PM, Baiss Eric Magnusson wrote:
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>
_______________________________________________
<email@hidden> mailing list
To unsubscribe, email: <email@hidden>
Searchable archive: <http://www.frontbase.com/devarchive.html>
Use your e-mail address as user name and you confimation ID as
password
To get your confirmation ID send an e-mail to<fb-dev-
email@hidden>
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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