Consultor Eletrônico



Kbase P27280: How to skip the write trigger when a record is created?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   6/19/2003
Status: Unverified

GOAL:

How to skip the write trigger when a record is created?

FIX:

When a record is created with CREATE and ASSIGN statements both create and write triggers are fired.
CREATE customer. /* fires create trigger */
ASSIGN custNum = 100 /* fires write trigger */
name = "Cust 100"
.

The write triger should contain at the very beggining:
IF customer NEW then leave.
This will make write trigger not doing anything for newly created records.