> Apparently it is already in insert mode.

...so it's trying to post the previous record?


My simplified code for inserting a new record looks like this:

try
{
qryAddCall->Prepare();
qryAddCall->Insert(); <------- 'required field' error

// Populate fields here

if ( qryAddCall->NeedToPost )
qryAddCall->Post();

qryAddCall->Close();
qryAddCall->Unprepare();
qryAddCall->IB_Transaction->Commit();
}
catch(Exception& e)
{
qryAddCall->Close();
qryAddCall->Unprepare();
qryAddCall->IB_Transaction->Rollback();
}


so whenever my routine is called it is always closed and committed or rolled back. On my PC this routine can be called time after time with no issues, but on one customer site it always throws the required field exception.