Multiple column FKs

[nguyenk]

Let's say I have a Table A with composit PK. I Have another Table B that need to point on Table A using 2 local columns.

Basic SQL would be :

ALTER TABLE B ADD CONSTRAINT B_TO_A FOREIGN KEY ( FK_COL_1 , FK_COL_2 ) REFERENCES B ( PK_COL_1 , PK_COL_2 )

I'm getting error :

TDBMException : PropertyDescriptor for B.FK_COL_1 not found in A

[Zheness]

Hello,

Same problem here.

Any update on this issue ?

Thanks :)

[moufmouf]

This should be fixed in 5.1.12.
Awaiting the port to the master branch to close this issue.