Re: OLD and NEW values in triggers

I don't think there is. Don't forget to keep your triggers very short, they need to be "recompiled" each time they are activated, calling a stored procedure from your trigger is more performant. Do you need coding that accesses each one of the fields?

-- 
Kind reGards,

Gerard
(ghp_at_santens.be; ghp_at_skynet.be)

gino.blyau_at_dg19.cec.be schreef in artikel <875017261.27164_at_dejanews.com>...


> Isn't there a possibility to use a kind of record

> structure:OLD.<TABLENAME> and :NEW<TABLENAME>in a trigger.It is a

> nuisance to use for every field this construct ofOLD and NEW, especially

> because we have tables with more than 50 columns.

> 

> -------------------==== Posted via Deja News ====-----------------------

>       http://www.dejanews.com/     Search, Read, Post to Usenet

>