It indicates that it's trying to append 0s instead of nulls to all of the unspecified fields. (Which are all of type integer.)

--- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@...> wrote:
>
> What does the SQL trace monitor indicate?
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of masonwheeler
> Sent: Thursday, March 7, 2013 6:13 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Attempting to AppendRecord a valid record causes an FK
> violation on a null field
>
> 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?
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>