Kbase P24498: Can a database trigger be disabled when the name of the tabl
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/10/2003 |
|
Status: Verified
GOAL:
Can a database trigger be disabled when the name of the table is not known until runtime?
FACT(s) (Environment):
Progress 9.1D
FIX:
Yes, this is possible.
First you have to get the buffer handle of the table you want to disable the trigger and then apply one of the two following buffer handle methods:
DISABLE-LOAD-TRIGGERS
DISABLE-DUMP-TRIGGERS
For example use can use the following code:
DEFINE VARIABLE htab AS HANDLE.
DEFINE VARIABLE cTableName AS CHARACTER INITIAL "customer" NO-UNDO.
CREATE BUFFER htab FOR TABLE cTableName.
htab:DISABLE-DUMP-TRIGGERS().