Subject | Foreign key violation, where there isn't |
---|---|
Author | Sandor Tamas |
Post date | 2008-05-27T14:23:07Z |
Hi,
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.
Is there something I don't know about foreign keys, or is there
something FB doesn't know about my foreign keys? :-)
Any advices welcome!
Thanks,
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.
Is there something I don't know about foreign keys, or is there
something FB doesn't know about my foreign keys? :-)
Any advices welcome!
Thanks,
SanTa