CODEWITHSUNDEEP
openedgeprogress-4gl
Bharat
Bharat

Reputation: 177

How to check trigger action working for a table? How do I know its DISABLED/ENABLED?

Is there any query to check this?

Upvotes: 0

Views: 410

Answers (1)

Mike Fechner
Mike Fechner

Reputation: 7192

If you cannot just see the effect of the database trigger (it will be doing something, assigning field value, updating additional data, performing validation, etc.) you can use 4GL Client logging:

LOG-MANAGER:LOGFILE-NAME = "c:\temp\client.log".
LOG-MANAGER:LOG-ENTRY-TYPES = "4gltrace:5,4glmessages".
LOG-MANAGER:CLEAR-LOG ().

/* this will execute the schema create trigger */
CREATE Customer.

UNDO.

This will show that it's returning from the DB trigger in the logfile:

[22/01/17@11:49:42.013+0100] P-158784 T-160248 3 4GL 4GLTRACE       Return from Main Block "Customer" [sports2000trgs/crcust.p]

So it must have been executed.

Upvotes: 3

Related Questions