Consultor Eletrônico



Kbase P9456: Where are the triggers that are actually firing?”
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   3/11/2003
Status: Unverified

SYMPTOM(s):

Where are the the schema table triggers located?

FIX:

Use the following code to output a list of all the tables and their database schema triggers to the text file “myTriggers.txt”:

OUTPUT TO “myTriggers.txt”.

FOR EACH _File NO-LOCK,
EACH _File-trig OF _File NO-LOCK:
DISPLAY
_File._File-Name
_File-trig._Event
_File-trig._Proc-Name.

END.

OUTPUT CLOSE.