Property Editor: SQL Action

SQL Action properties are configured via the Events page of a Property Editor.

A SQL script execute can be triggered when the task form is opened or closed. Specify whether a result code is returned when script execution is complete.

Note: AfterClose events are triggered by:

  • Closing the object

  • Closing the Application

  • Logging out of the current configuration database connection

If a result code is returned, enter the text of the messages that will be displayed for result = 1 (confirm before proceeding) and result = 2 (abort).