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