This topic is locked

Keep track of record changes in the record it self

7/25/2011 7:44:40 PM
ASPRunnerPro General questions
C
Cmdias author

I was wondering if we can (with asp runner) keep track of record changes inside the record itself.
Ex: every time a record is changed we add (and keep the previous data) an entry with date, login to a field called "last changes" in the record itself.
Thx

Sergey Kornilov admin 7/26/2011

You may want to check 'Audit' feature:

http://xlinesoft.com/asprunnerpro/docs/audit.htm

C
Cmdias author 7/26/2011

Thx, i already looked at that but cant figure out how to add the data into the item itself....



You may want to check 'Audit' feature:

http://xlinesoft.com/asprunnerpro/docs/audit.htm

Sergey Kornilov admin 7/26/2011

Audit feature logs all changes to a separate table.
If you need to store all changes in a separate field within the same record you need to implement BeforeEdit event that will compare old and new field values that then write changes to LastChanges field.
If you have a valid support contract post your application to Demo Account and we'll assist you with this. 'Demo Account' button can be found on the last screen in the program.

C
Cmdias author 7/26/2011

Perfect, i just needed to know if it could be done before asking my boss to purchasse.
Thx



Audit feature logs all changes to a separate table.
If you need to store all changes in a separate field within the same record you need to implement BeforeEdit event that will compare old and new field values that then write changes to LastChanges field.
If you have a valid support contract post your application to Demo Account and we'll assist you with this. 'Demo Account' button can be found on the last screen in the program.

Sergey Kornilov admin 7/27/2011

Sure, it's possible.