Good day
=-0=-=-0-=0

Okay I got more info on this. It is on one of the main table

It is something like this (shortend version)

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)

The TIBOQuery's - KEYLINKS is set to ACCOUNT.ACC_CODE

KeyLinksAutoDefine is FALSE

We DON't use chached updates.

It SEEMS it does not Allow multiples of the P_CODE !!!!

this is the odd part as this table MUST be able to take more than one as long as it exists in the foreing table

Can somebody please give some more light on this please

Thanks

Johannes


At 09:27 AM 26/04/2006, you wrote:

>Good day.
>=-00=-0=-=-0
>
>Ekstra note from this.
>
>Looking at the log files. I don't really know what table/s this is happening on ! It is happening on
>the a clients machine. Thus hard to debug
>
>Thanks for any help
>
>Johannes
>
>At 09:15 AM 26/04/2006, you wrote:
>
>>Good day all
>>-0==-0-=00-=
>>
>>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
>>
>>What is the ODD part is that it works for 2 accounts and then it creates the error.
>>Note that with every save we use db.applyupdates
>>
>>Thus it is all done in controlled transactions.
>>
>>If anybody can please help us here.
>>
>>Thanks
>>
>>
>>
>>
>>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
>>
>>
>>
>>___________________________________________________________________________
>>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
>> without the need for BDE, ODBC or any other layer.
>>___________________________________________________________________________
>>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>>keyword-searchable FAQ, community code contributions and more !
>>Yahoo! Groups Links
>>
>>
>>
>>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links
>
>
>
>