New properties and APIs

AuditPlus API procedures added

New procedures were added to the AuditPlus API.

  • AuditPlusDeleteOldRecords: Allows user to delete all audit records that are older than a given date
  • AuditPlusDeleteOlderThan1YearRecords: Allows user to delete all audit records that are older than 1 year
  • AuditPlusGetLastRecordForTable: Returns the latest AuditRecordId given the name of a table and the serialized record's key
  • AuditPlusGetLastRecordForTrn: Returns the latest AuditRecordId given the name of a transaction and the serialized record's key

All API procedures can be found under the 'AuditPlusAPI' folder

AuditPlusAPIFolder


Save procedures code on fail

If an error occurs while any AuditPlus procedure is generated, AuditPlus will save the procedure's source code in the file system, and will display the error and the file's location.

This will allow users to analyze (and fix) the error in the generated source code.

Custom trigger names

New properties were added in transactions, that allows the user to define custom trigger names for that transaction.

This can be used in scenarios where more restrict naming must be used.

AuditPlus will not check the validity of the specified names.

AuditPlusCustomTriggerNames

Improvements in parallel transactions

Some minor improvements were made to prevent errors using parallel transactions.

Triggers source code extension point added

This feature allows the user to extend the trigger's source code, for some advanced special cases where custom (but systematic) logic is needed.

To enable this feature, the user must create a procedure named: 'AuditPlusAppendTriggerExtension'

The procedure must define the following parm:

Parm(in:&TableName, in:&TriggerOperation, in:&TriggerSection, out:&SourceCode);

Where all parameters must be character or varchar.

AuditPlus will then insert calls to the procedure in the middle of the trigger source code generation process.

AuditPlusAppendTriggerExtensio