Re: DELETE trigger
All of it is available in the FOR EACH ROW section using a REFERENCING
clause. Like so:
CREATE TRIGGER d_trig_1 DELETE ON table_1 REFERENCING OLD AS defunct
FOR EACH ROW (
INSERT INTO table_1_log
VALUES ("D", CURRENT, defunct.key1, defunct.key2 )
);
Art S. Kagel
"André Treffeisen" wrote:
>
> Hi,
>
> I am a bit confused of the informix triggers ...
> What information of a deleted row is accessible in a delete trigger ?
>
> Cheers,
> André