I have a Northwind database and I would like to make a subtype/supertype relationships on Employees using the ReportsTo (of type int); Specifically make a TopBrass subtype where ReportsTo is Null, or SecondString where ReportsTo equals 2.

but ReportsTo doesn't show in the discriminator field drop down in LLBLGen pro V2.0 after clicking "create subtype for this entity".

So how do I get ReportsTo to show in the discriminator field drop down? (or any field I make... as I have added indexed bit fields and nothing shows in the discriminator field drop down after I refresh the catalog)

I would think that the discriminator column needs to not allow null. Can you make TopBrass 0 and not allow nulls?

nullable fields and FK fields aren't recommended nor supported as discriminator fields. Discriminator fields are fields which are non-nullable and not an FK, so they stay the same value as long as the entity lives.

So how do I get Fields to show in the discriminator field drop down for any field I make?

I have added indexed bit fields and nothing shows in the discriminator field drop down after I refresh the catalog. (and it does show as a field in the fields list)

Does this field AllowNull in the database? and/or is it a FK field?w

'ReportsTo' is a int FK and allows nulls. (the first attempt I made)

however the field I added in my second attempt is not; I added a 'IsManager' bit field that does not allow nulls, it shows in the fields list but not in the discriminators drop down.

Would you try an int field.

Ok that works, thanks!

btw manual says bit works

John.T.Gold wrote:

Ok that works, thanks!

btw manual says bit works

Ok, but not a nullable bit . If a field is nullable, it's not going to work.