Subject | IB_Query insert statement / Trigger "Before insert" |
---|---|
Author | softrolli |
Post date | 2007-01-23T10:18:38Z |
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 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