hi ,
i am tring to add a foreign key to a table which contains some data ,
and it seems i can't if i don't delete all the data to the (child) table ,
fortunately it is only test data : i delete data and i can add the FK
without any trouble .
... is it possible to add a FK without deleting data ?

.... or maybe i am wrong in other ways , here the error message :
violation of FOREIGN KEY constraint "".
violation of FOREIGN KEY constraint "PK_TCAUDOCUMENTI" on table
"TCAUDOCUMENTI".

i use Firebird 1.5. and ibExpert .

thanks

Maurizio
Chiacchiera con i tuoi amici in tempo reale!
http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com