I lacked some information... let me try again....

Firebird 1rc2, IBO4 Gc, BCB 6Pro

I have a table in which several fields have default
values defined one of which is 'SortFlag'.
In isql if I run the command:
insert into views (RecNum) values (1);
It creates a record correctly where the other fields that
have default values defined are set.

However in my C++ code when I do:
Views->Insert();
Views->FieldByName("RecNum")->AsInteger= 1;
Views->Post();
I get the error:
EIB_DatasetError with message "SortFlag is a required field"

"Views" is a TIBOQuery

Why isn't this working in my code?

bhata