What I posted was not quite correct. My code actually looks like this:

qryAddCall->Prepare();
sTrace += "b";
qryAddCall->Insert();
sTrace += "c";

and the code at the customer site throws the exception when Insert is called. Why does it warn about the 'required field' column there and not when the data is posted?

--- In IBObjects@yahoogroups.com, "tickerboo2002" <egroup@...> wrote:
>
> Using IBO v4.8.7 with BCB2006 and I'm experiencing a weird problem at a customer site (works fine for me). Here's the ghist of my code:
>
>
>
> if ( CallWasPreviouslySaved )
> {
> qryAddCall->Prepare();
> qryAddCall->ParamByName("CALL_ID")->AsInteger = pCall->CallID_DB;
> qryAddCall->Open();
> }
> else
> {
> qryAddCall->Prepare(); <-----
> qryAddCall->Insert();
> }
>
> I'm using prepared edits/inserts and when I call Prepare (prior to Insert) I get an exception being thrown 'CONTACT_ID is a required field'. The CONTACT_ID column is a not NULL column of the table.
>
> Whenever I test this here, it works with no issues. However, on a customer site, they always get the exception being thrown when 'Prepare' is called. I can imagine this error being thrown when I go to Post/Commit data, but not when performing a Prepare.
>
> Can anyone cast any light on why/how this could be happening and are there any properties of the TIB_Query that could be causing this?
>
> Many thanks.
>