Skip to Content
0
Former Member
Jun 15, 2007 at 04:20 AM

Reading the DBTABLOG Table

4985 Views

I have developed a program to read the DBTABLOG Table entries which keeps a Log Records of Table Changes.

On update of an entry in any table (say TCJ1T), DBTABLOG stores the entry that was updated ie. the old entry.

TO get the new entry I read the key fields of the table TCJ1T form DBTABLOG and query TCJ1T using a select query. The issue is that if an entry is updated twice I can only get the latest updated record if I read the table TCJ1T and the previously updated value is lost.

Is there a way to read the old value , new value using DBTABLOG.

Thanks and Regards

Ashwin