Is there a alternative on Assign Trigger for a field extent

[Kalyansid]

Hi,

I am using Assign triggers to check for any modifications on table field values. It worked fine for all except for one of the field which is a array of 4 and I am not able to use the assign trigger on this array field. Is there any alternative way (trigger) to capture the change in array fields.

thanks & regards

 

[RealHeavyDude]

Using datbase triggers to generate audit trails is - IMHO - not a very good solution - but it depends on the application architecture and how you handle your business logic.

You don't say anything about the Progress/OpenEdge version you are running. This is essential information as there has been introduced an audit functionality to the database engine in one of the more recent versions of OpenEdge (10.1A).

You could also implement it on the table level in the write trigger of the table. Using dynamic buffers it would be easy to check the modifications. This would also have the advantage that the logic would not fire per field but per record instead.

Regards, RealHeavyDude.