We have a number of entities that use single table inheritance. When a
relationship points to the parent entity it does a separate fetch for each
child entity. I know this is how the inheritance was designed originally. Has
anything been done so that it does on query and applies the qualifier
On 2 Mar 2009, at 23:43, Chuck Hill wrote:
On Mar 2, 2009, at 1:42 PM, Kieran Kelleher wrote:
I always thought that EOFetchSpecification.setFetchLimit( int n)
would generate SQL with LIMIT n tacked onto the end of the SQL
statement, but it appears not to.
This is the default behavior as
You can use ERXSqlHelper.limitExpressionForSQL, or here is a utility method I
used once to convert a fetchspec to one with limited SQL in the SQL hints. The
code is only used in one place in one project, so no guarantee of reliability
applies to it right now:
Usage Example:
Which version of WO? I thought it would not do this if everything in the
inheritance hierarchy was in the same table.
Chuck
On Jul 12, 2010, at 7:39 AM, Jeffrey Simpson wrote:
> We have a number of entities that use single table inheritance. When a
> relationship points to the parent entit