Re: post-change and on-validate-field trigger
From: Steve Yam <syam_at_axionet.com>
Date: 1995/06/13
Message-ID: <3rklpa$hdp_at_blues.axionet.com>#1/1
Date: 1995/06/13
Message-ID: <3rklpa$hdp_at_blues.axionet.com>#1/1
In article <3ri50q$70a_at_artecon.artecon.com>, quach_at_ext423.artecon.com
says...
>
>Hi all,
> I'm still confusing on POST-CHANGE and ON-VALIDATE-FIELD.
>Please help. When is the best time to create either one for the
>field trigger?
>
>Phuong
>Thank you.
>
Post-change means the AFTER operation trigger. On-validate-field means
the BEFORE operation trigger. There are two major different.
- Before operation trigger involves one additional record fetching. It means that same record may have two fetch operation involved. But After operation trigger needs only one because the trigger is fired after the record is fetched into PGA.
- After operation trigger has one restriction. Trigger cannot change the contents of attached fields for update or insert operation. THis is because AFTER means the contents has been wrote to the associated records.
Normally, AFTER trigger is good for OTHER table operations such as history inventory, statistic calculation... BEFORE trigger is good for attached fields manipulation such as conditional amendment on field contents.
Steve. Received on Tue Jun 13 1995 - 00:00:00 CEST