Good day all
-=00-=0=-=0-=-0

Please forgive if this question is not at the correct list. But I don't really know where it must be

We have an odd error message with IBOBjects 4.6A.
This is on interbase 5.6
Delphi 5


SQL ERROR MESSAGE:
Invalid insert or update value(s): object columns are
constrained - no 2 table rows can have duplicate column values

The TABLE's that causes the problem is as follows

CREATE TABLE A (
ACC_CODE T_ACC_CODE NOT NULL,
P_CODE T_CODE NOT NULL,

)

ALTER TABLE A
ADD CONSTRAINT INTEG_11
FOREIGN KEY (P_CODE)
REFERENCES P

ALTER TABLE A
ADD CONSTRAINT INTEG_10
PRIMARY KEY (ACC_CODE)

It Seems ASIF it does not want us to ADD MORe than ONE entry in table A that is linked to ONE entry in table P


If anybody can please help us here.

Thanks in Advance

Johannes Pretorius
(Programeerings Departement- Promed)

Tel : +27 11 607-3300
Faks : +27 11 622-6939
webtuiste : http://www.promed.co.za

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you are not the intended recipient, any review, re transmission,
disclosure, copying, modification or other use of this email message or
attachments is strictly forbidden. If you receive this email message in
error, please contact the author and delete the message and any
associated files from your computer. Also the contents of this e-mail
is considered confidential.
Thank you