"What Columns Changes" project

[RD_Man]

I am on a mission to develop a crude Change Order System. When a table gets updated, what options are available to compare the Before and After to log which columns actually changed?

It would also be nice to have both values, Before and After, for any column that changed.

Any guidance would be appreciated.

Thanks,

Mike

 

[jp-uk]

take a look at triggers, they can fire off code when data is updated/deleted...

 

[RD_Man]

Thanks jp-uk,

Here is what I came up with after I discover the words "OLD BUFFER".

If I am doing anything wrong or illegal here, please let me know.

TRIGGER PROCEDURE FOR WRITE OF bank OLD BUFFER oldbank.
If oldbank.account <> bank.account THEN
Do.
Create chng-hdr.
ASSIGN chng-hdr.chg-dt = TODAY
chng-hdr.chg-time = TIME
chng-hdr.chg-by = Caps(user-login)
chng-hdr.chg-file = 'Bank'
chng-hdr.chg-field = 'Account Number'
chng-hdr.chg-was = oldbank.account
chng-hdr.chg-is = bank.account.
End.