menu_banner (2K)

audit_tbl(upd4) - Generate SQL

(there is no screen)

The purpose of this function is to generate the SQL query for an entry in the audit database so that the change, which maybe an insert, update or delete, can be duplicated in another copy of that database.

It will create a single SQL query and append it to a file named audit/sql/audit_export.sql. This file can then be moved to another directory and renamed as appropriate.

This form is accessed by an option on the navigation bar in the List Audit detail screen.

For a complete description of how this type of form works please see Transaction Pattern UPDATE 4.