Subject | RE: [firebird-support] Foreign key violation, where there isn't |
---|---|
Author | Mercea Paul |
Post date | 2008-05-27T16:39:29Z |
Hi SanTa
match some Id in other table!
What error you get?How look your sql?
Regards,
Paul
>I have a problem:[PM] If you don't have foreign key database have no idea that record must
>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.
match some Id in other table!
What error you get?How look your sql?
Regards,
Paul