Apple

2015-04-24 17:31 GMT+01:00 Chuck Hill <email@hidden>:

Single Table is usually the best choice.

On 2015-04-24, 9:30 AM, "HOUNKPONOU Ronald" wrote:

Hi Chuck,
I am using horizontal inheritance.

I've choose it after i read the section on inheritance in Practical WebObjects.

But i read it again may be i miss something

2015-04-24 17:26 GMT+01:00 Chuck Hill <email@hidden>:

It sounds like you used Vertical Inheritance. I generally don’t recommend it. One reason is that you can’t enforce foreign key constraints like this. I suggest reading the section on inheritance in Practical WebObjects

Chuck

On 2015-04-24, 9:22 AM, "HOUNKPONOU Ronald" wrote:

Hi,

have a problem with Entities and inherance.

I have 3 Entities AbstractPerson, Person and Account.

AbstractPerson is abstract.

Person inherit from AbstractPerson.

An AbstractPerson can have many Accounts.

I can esaly create a Person.

The problem is that when I try to insert an Account that belongs to a Person, i got this ERROR :

ERROR: an insert or update instruction on the « Account » violate the foreign key constraint « account_abstractperson_fk »

Details: The key (abstractpersonid)=(1) is not present in the table « abstractperson ».

References:
	>problem with Entities and inherance (From: HOUNKPONOU Ronald <email@hidden>)
	>Re: problem with Entities and inherance (From: Chuck Hill <email@hidden>)
	>Re: problem with Entities and inherance (From: HOUNKPONOU Ronald <email@hidden>)
	>Re: problem with Entities and inherance (From: Chuck Hill <email@hidden>)
	>Re: problem with Entities and inherance (From: HOUNKPONOU Ronald <email@hidden>)