| Subject | Attempting to AppendRecord a valid record causes an FK violation on a null field |
|---|---|
| Author | masonwheeler |
| Post date | 2013-03-08T01:13:13Z |
I've got a table that contains a nullable field that's connected to another table via a Foreign Key constraint. It's perfectly valid to insert a NULL into this field.
I've got a TIBOTable object that covers this table.
If I call AppendRecord on this TIBOTable, and I don't provide enough parameters in the list to give a value to every field, the leftovers should be filled in with NULLs.
However, calling AppendRecord on this table and not providing a value for the FK field gives me a foreign key violation error from Firebird. Any idea why?
I've got a TIBOTable object that covers this table.
If I call AppendRecord on this TIBOTable, and I don't provide enough parameters in the list to give a value to every field, the leftovers should be filled in with NULLs.
However, calling AppendRecord on this table and not providing a value for the FK field gives me a foreign key violation error from Firebird. Any idea why?