Subject | Re: IB_Query insert statement / Trigger "Before insert" |
---|---|
Author | softrolli |
Post date | 2007-01-23T10:31:30Z |
--- In IBObjects@yahoogroups.com, "softrolli" <softrolli@...> wrote:
I am using Delphi 5 Professional and the DB is Firebird 1.5
>Ah, I forgot:
> Hello,
> I have defined a trigger to get the next ID (ID is the primary key)
> from a Generator, that is supposed to fire before insert (Position 0).
> In the Query I have automatically set the InsertSQL Statement to
> insert a new record.
> Now, when a record is inserted, I get the Error "ID" is a required
> value ".
> How do I get a Database trigger to fire before the insert statement of
> a Query Component?
>
> Rolf
>
I am using Delphi 5 Professional and the DB is Firebird 1.5