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