• If a text field is a part of the table, then separate statement should be added as a part of the trigger for the table. But it will bring the performance a little bit down.  In generator, this is can be analyzed.

    There will be 3 solutions:

    1. Update record in the audit table

    2. Create a new record for the text column only in the audit table, e.g. will be 2 records if text and the other fields are updated.

    3. Create separate table with next columns:  TableName, TEXTCOLUMNNAME, TextColumnValue and insert the text changes for all tables in database into one table.

    I think, the third one is the most elegant and has the best performance results.

    Leo P.