Screen Data Scripts

This screen allows you to generate and maintain Scripts that are activated in association with Database Triggers.  You should have detailed knowledge of Ostendo’s Database Triggers before defining and using Screen Data Scripts

Entry and Display fields

Screen:  From the drop-down select the screen against which this Screen Data Script will be activated.

Table Name:  For the screen selected in the previous field Ostendo will present you with a drop-down list of all Table Names used by that screen.  Select the Table Name against which the script is being maintained

SQL Type:  From the drop-down list select the screen event at which this Data screen will be applied.  The options are Insert, Update, or Delete.

Script Name:  This will show - in a drop-down list - all Custom Scripts created via screen ‘Custom Scripts’ and flagged as a Screen Data Script.   Select the Custom Script that will apply to this entry.

Buttons

Close: This will close the Screen Data Script screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

Add: This will take you to a new line for entry of a new Screen Data Script record.

Save: This will save the current data without exiting the screen

Cancel: Any changes made to the Screen Data Script record or the last time the ‘Save’ Button was pressed will be lost.

Delete: This will delete the highlighted Screen Data Script record