Subject Re: [IBO] TIB_Query->Insert throws on non-NULL fields
Author Lester Caine
> This used to work and I'm fairly sure I haven't changed any of the
> TIB_Query properties.
> Using the default TIB_Query properties, I call:
> qry->Insert();
> IBO throws an exception warning me that:
> "myfieldname is a required field"
> Tracing into Insert() it goes into SysInsert, SysPost and finally
> CheckRequiredFields where the exception is thrown.
> I know I can set CheckRequired=false, but I want this to check the
> params when I've finished editing the row.
> None of my other queries throw on non-null fields when I insert a row.
> Any ideas?

The problem is in the database. One of the fields you are
not filling in the Insert is expecting a non-NULL value. You
need to find out which one it is and put someting into it
before the insert.

Lester Caine
L.S.Caine Electronic Services