User-Defined Scripting for Table and Column Events

                                 

User-defined scripting allows customer specific business rules and validations to be assigned to a specific table or column level events. These scripts can be invoked automatically, without user interaction.

Note The Allow External Access check box in Company Maintenance must be selected to enable user-defined scripting. This can be used when developing debugging scripts to restrict scripting to a specific test company.

The following table illustrates the events.

Table Events

Execution Description

Script Initialization

When scripting is first initialized for a business object

Set Defaults

When defaults are set for a new record

Pre-Write

Before a record is written with the ability to prevent the write

Post-Write

After a record is written

Pre-Delete

Before a record is deleted with the ability to prevent the delete

Post-Delete

After a record is deleted

Post-Read

After a record is read

Pre-Totals

Before totals are calculated (only on line detail tables)

 

 

Column Events

 

Pre-Validation

Before a column value is validated (after dictionary validation, but before MAS and Master Developer validations)

Post-Validation

After a column value is validated

Note  Pre-events (except for Pre-Totals) can return a failure message and interrupt further processing. Because these validations are enforced in the business object, these messages are displayed in the MAS data entry tasks, and also logged if invoked externally using Visual Integrator or the object interface.