4 Replies Latest reply on Dec 30, 2016 10:33 AM by siplus

    how to access old record data prior to commit new data. SQL record query seems to return new values even before commit

    user28351

      Trying to easily access the old record data prior to committing new data. I know i can store all the old data by programmatically storing every bit of the old record in variable/s before committing the new data but this is very labor intensive and  surely this cant be the only way of getting at the old data. Other systems have the concept of record buffers to allow this functionality. I've  tried using ExecuteSQL to re-read a record prior to committing the new data but this returns the new data contrary to other blog posts that indicate that ExecuteSQL does not use the current found set to find records. For interest sake, the reason for needing this is to write an audit trail routine to stores all changes to tables  including old and new values when records are updated.