I put CHECK_KEY=COMPUTED in the columnattributes in the TIBOQuery
and that did not stop the message. The query I use does not specify the
columns. it is
a SELECT * FROM CHECKS Should I specify all the column names.

Thanks for the quick response.

Jack


Jason Wharton wrote:

>
> You can place a setting in the ColumnAttributes to flag the column as
> NOTREQUIRED or also as COMPUTED, depending on your circumstances. In
> either
> case you are overriding the NOT NULL status of the column. IBO is not
> aware
> of what your trigger does.
>
> I also recommend that you update your trigger with a check for NULL. I
> presume you only want it to provide a value if the NEW value is NULL.
>
> Jason
>
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com <mailto:IBObjects%40yahoogroups.com>
> [mailto:IBObjects@yahoogroups.com <mailto:IBObjects%40yahoogroups.com>]On
> > Behalf Of jack_engleman
> > Sent: Wednesday, November 29, 2006 3:47 PM
> > To: IBObjects@yahoogroups.com <mailto:IBObjects%40yahoogroups.com>
> > Subject: [IBO] Problem with Trigger on Table during insert.
> >
> >
> > This code has worked in using the BDE for the last 5 years, but in the
> > converted I am having a problem with a table checks and using a
> > TIBOQuery to add a row to this table and the software complains the
> > 'CHECK_KEY must have a value'.
> >
> > this trigger is created on the CHECKS table.
> >
> > CREATE TRIGGER SET_CHECK_NUM FOR CHECKS
> > BEFORE INSERT AS
> > BEGIN
> > NEW.CHECK_KEY = GEN_ID(CHECK_KEY_GEN, 1);
> > END^
> >
> > In the code below when I try to post I get the Error.
> >
> > Query_Checks.Close;
> > Query_Checks.Open;
> > Query_Checks.Insert;
> > Query_Checks.FieldByName('ACC_KEY').AsInteger := WWAccKey;
> > Query_Checks.FieldByName('EMP_KEY').AsInteger := EEmp_Key;
> > Query_Checks.FieldByName('CHECK_DATE').AsDateTime :=
> > DTP_CheckDate.Date;
> > Query_Checks.FieldByName('PAY_DATE').AsDateTime := Date;
> > Query_Checks.FieldByName('CHECK_NUM').AsString := Edit_check.Text;
> > Query_Checks.FieldByName('AMT').AsCurrency := Amt;
> > Query_Checks.Post;
> > Query_Checks.Close;
> >
> > Can somebody give some pointers how to get around this problem??
> >
> > I am using the 4.6 Bc IBO version.
> >
> > Thanks in Advance
> >
> > Jack
> >
>
>