Subject RE: [firebird-support] Foreign key violation, where there isn't
Author Mercea Paul
Hi SanTa

>I have a problem:
>I have to tables, one has a PK, the other has a FK for the previous
>table's PK.
>But then, when I try to post new record, it sais I have a violation of
>Foreign key on table. It is strange, because I tried it by hand, and
>with IBExpert's help to choose the proper record from the primary table.

>Even when I tried it without foreign key, I was able to insert the
>record, but then, it dropped me an error creating the foreign key.

[PM] If you don't have foreign key database have no idea that record must
match some Id in other table!
What error you get?How look your sql?