create in triggers

[vice]

hi,

i try to write a trigger which copy the record if you try to modify them and write the modified data only in the new record. with this concept i will create a easy history.

so i must create a new record in the write trigger but if i try this i get the error that the create trigger is called but an other trigger is still running.

i have also disabled the triggers with

DISABLE TRIGGERS FOR LOAD OF xyz.

but this has no effect? so is this a bug or has this function no effect in a trigger procedure? ( Progress 9.1D )

???

thanks
thomas

 

[curly]

Error: Attempt to CREATE a <table> record in <procedure> while a trigger is executing. (3168) is displayed when you try to create a new record using the same buffer as the trigger buffer.

Solution: define a new buffer for the same table and use it to create your new record(s)

Warning: by creating a new record in the same table you trigger the same trigger code again – this time for the new record = you could end up in recursive loop. You have to properly handle recursive calls OR use a different table to store your history data.

Regards,
Marian

 

[vice]

thank's for your answer, i had solve it with an extra table
but if i remember corretly i had used an extra buffer.

greetings
Thomas