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
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.
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.
Some minor improvements were made to prevent errors using parallel transactions.
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.
|