Subject Re: [firebird-support] Problem with foreign key
Author Helen Borrie
At 09:02 PM 28/04/2005 +1000, you wrote:
>Hi Helen,
>No, the DB as been stopped and restarted since the original master
>record was created.
>And I still can not get it to work :-(

Put a monitor on the run-time execution and check exactly what is being
passed in that parameter. If it is null, you will get a FK violation
because of the referential actions you prescribed. You'll also get a
violation if the FK column is varchar and the referenced PK column is char,
or vice-versa, unless both are filled to the maximum length.