NO ON WRITE OF TABLE trigger TRIGGERED

[davidof]

i have a "on write of table dele ..." trigger, which work on closely every update i make - with ONE exception. I defined a buffer writing
on this dele table called b_dele. With all other examples it works pretty fine. There are no transactions used.

FOR EACH b_dele
EXCLUSIVE-LOCK:

b_dele.iStatus = {yyy}.

RELEASE b_dele.

END.

I do not know why this ON WRITE trigger isn't called.
Please help me, thanks david

 

[Casper]

If this trigger is also for table dele, then you just created an infinite loop. Each time the dele table is written the trigger fires.

(BTW if an exclusive-lock is used on a database table a transaction is always involved)

If you debug the code you will see what happens.

Casper.

 

[Casper]

Hmm, after reading your post more closely you probably didn't put previous code in the on write of... trigger....

Some more things:
-If you don't change the field then the trigger isn't fired.
-If there are no dele records the trigger (obviously) isn't fired.
-if an error occurs with the assign the trigger isn't fired.

Put DEBUGGER:INITIATE() and DEBUGGER:SET-BREAK() in your procedure to find out the real cause.

Casper.