Re: SQL from single table inheritance

You need a deep FetchSpec .... isDeep = true. See the constructor  
with the most arguments for EOFetchSpecification in the javadocs API.

HTH, Kieran

PS. On a side note, I have found that Strategy Design pattern as a  
substitute to EOF Single Table Inheritance to be much easier to work  
with and far more flexible .... and EOF in general is more well  
behaved when not dealing with inheritance hierarchies.

On Feb 23, 2007, at 2:53 PM, Julian Gómez wrote:

> This seems like a basic question, but I haven't found anything  
> about it yet.
>
> I have an entity with a half dozen subclasses. The amount of data  
> is fairly small, so I set up with single table inheritance.  
> However, the generated SQL is not working out. If I click on the  
> main class, it generates SQL for it only (it's abstract). If I  
> click on a subclass, it generates SQL only for the subclass. How do  
> I get the SQL for the table which is the union of all the  
> subclasses, i.e. the one parent class table with all the columns  
> anybody will ever need?
>
> I'm using EOModeler still; I wasn't able to get XCode to even  
> enable the menu item to generate SQL.
>
> Thanks.
>
> ______________________________
> immi
> Julian Gómez
> Senior Applications Engineer
> o: 650.572.3238
> m: 650.483.6107
> e: [email protected]
>
> www.immi.com
> 1510 Fashion Island Blvd. Suite 300
> San Mateo, CA 94404
>
>
> _______________________________________________
> WebObjects-dev mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/webobjects-dev