Subject Re: [IBO] Newbie Insert SQL question.
Author Aage Johansen
Walter Ogston wrote:
> ...
> EDatabaseError with message 'Field 'CLIENT_NUMBER' must have a value'.
> ...

The "Required" property will by default indicate that the PrimaryKey must
have a value (when inserting a new record). When the PK is set by the
server you will have to change the property (to be allowed to send an
insert without a value for a not-null field).

Btw, the TIB_DSQL component is your best choice for inserts.

Aage J.