prefetching and derived attributes - wrong SQL

Anders Peterson <[email protected]>
Newsgroups gmane.comp.web.webobjects.devel
Organization Optimatika
Message-ID <[email protected]>
Hi,

I have a FetchSpecification (built in code) that fetches "transactions". 
The entity TransactionRow has a derived attribute defined as 
price*quantity. To speed things up I have set the FetchSpecification to 
prefetch on the reference to "TransactionHead".

Fetching the TransactionRows works, but when (pre)fetching the 
TransactionHeads we get an exception caused by trying to query 
price*quantity on TransactionHead. EOF has generated incorrect SQL.

If I do not prefetch on the reference to TransactionHead or if don't 
qualify on price*quantity everything works fine. If I do both of those 
things I get incorrect SQL.

I qualify on many different attributes in both TransactionRow and 
TransactionHead. Everything works just fine except the combination with 
a derived attribute and prefetching.

/Anders
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.