Oops, yes, there is a property for PreparedInserts as well.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of masonwheeler
Sent: Monday, March 11, 2013 6:22 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: Attempting to AppendRecord a valid record causes an FK
violation on a null field

True. (But isn't this an Insert? PerparedInserts is set to False.)

--- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@...>
wrote:

>
> What is PreparedEdits set to?
>
> Jason
>
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On

Behalf

> Of masonwheeler
> Sent: Sunday, March 10, 2013 9:27 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Re: Attempting to AppendRecord a valid record causes an FK
> violation on a null field
>
> 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
> >
>
>
>
>
> ------------------------------------
>
>

___________________________________________________________________________

> 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
>

------------------------------------

___________________________________________________________________________
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