Consultor Eletrônico



Kbase P138121: How to find the old field name and the new field name values from the _aud-audit-data._event-detail
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   03/12/2008
Status: Unverified

GOAL:

How to find the old field name and the new field name values from the _aud-audit-data._event-detail field ?

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.x

FIX:

The following provides an example of how to find the field names - old values and the new values from the _aud-audit-data._event-detail field :

The data separators are:
fieldname + chr(6) + data type code + chr(6) + oldvalue + chr(6) + newvalue + chr(7)

DO icount = 1 TO NUM-ENTRIES(_aud-audit-data._event-detail, CHR(7)):
cEvent = ENTRY(iCount, _aud-audit-data._event-detail, CHR(7)).
MESSAGE
"field:" ENTRY(1, cEvent, CHR(6))
"was:" ENTRY(3, cEvent, CHR(6))
"now:" ENTRY(4, cEvent, CHR(6))
VIEW-AS ALERT-BOX INFO BUTTONS OK.
END.