Single entity based on partitioned tables

Posts   
 
    
paulc
User
Posts: 11
Joined: 03-Oct-2006
# Posted on: 07-May-2009 18:20:00   

Is it possible to create an entity which maps on to 3 schema identical tables? I can envisage that you could have a view which unions the 3 tables together and then you could build an entity on that but then i guess updates and inserts would not be possible.

I know that creating a base table containing all of the fields and 3 subtables with no fields would generate correctly in llblgen via inheritance but i'd like to know if it's possible to do this without a single base table.

Thank you in advance for any help.

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 07-May-2009 18:25:15   

Sorry, I'm pretty sure it is not.

Matt