Hi

We have situation where we have a "supertypetable" User. There are serval subtables like DepartmentUsers wich have FK to this User table to extend it relations but still have to abillity to use the supertalbes ID as FK in other relations.

This is ideal for inheritance in Object world but dosent go very well with LLBL´s SelfService code.

Is there a way or a furture plan to make inheritance available? Maybe as an extend to the GUI where you specifie tables that should be part of the hiearachy?

Or is it impossible to make with the current structure?

Anders

Inheritance is planned for the april/may timeframe. Till then, you've to use the 1:1 relations I'm afraid.

Sounds great.

Anybody up to speed enough with SQL 2005 to know if this kind of thing is supported in it? Isn't it time we had databases that natively understood inheritence?

swallace wrote:

Anybody up to speed enough with SQL 2005 to know if this kind of thing is supported in it? Isn't it time we had databases that natively understood inheritence?

Check postgresql, it can do table inheritance right there in DDL

Sqlserver 2005 should work with the sqlserver 2000 driver, there might be some issues, I have to sort them out. I have beta2 of yukon here, but at the moment I won't spend time supporting beta stuff that's not finalized (as in: it has the possibility it will change), as most of the time it's a waste of time. When yukon reaches beta3 I'll check it out, to get a .NET 1.1 driver for it (.NET 2.0 has to wait till v2.0 of LLBLGen Pro)

We live in interesting times...