'you have mail' script after ... query

Each process step that is controlled with a query also has a script that is executed after the query. This is aVB script (Visual Basic Script) with which previously selected data can be subsequently changed. A postscript, i.e. a script that is executed "afterwards", has the advantage that a query no longer needs to be changed, i.e. it provides a certain basis of data and can then be individually adapted using a programming language. Since you have more options with a programming language, data can still be changed after the query under program control. A VBScript is provided with a certain set of variables that enable a database connection to the query data and establish a reference to the message.

View

The screen contains the syntax editor in the first place. In addition to the editor, there are a number of predefined variables and replacements, which are made available via a menu button. Below the VBScript editor there is a splitter which can be used to adjust the size of the editor and the rest of the screen. Below this is a list of all predefined variables that are passed to the VBScript, some of which are not visible as they contain the database connection, for example. Below this list is the output window in which the result is displayed. The result is the content of the table that was created by the query associated with the script and changed by the script.

Operation

Operate the elements on the screen as follows:

• Script Editor
  Enter/edit a VBScript here. The current syntax in the syntax editor is VB-Script, CodX-specific tables, functions and stored procedures are colored. You can find help on using the editor by clicking the help button in the editor.

• Variable defaults
  Here you will find the predefined variables that are transferred to the script as variables. You can adjust the"Variable value input" column by clicking on a value in this column with the mouse and then editing the value. The values of these variables are displayed in the "Variable value output" column after the script has been executed.

• Output result
  In this window, which is an embedded browser window, the result of the corresponding database table for which you have opened the script dialog is displayed. The content of the database table is displayed here in tabular form. This means that any adjustments you have made using the VBScript are immediately visible.

• OK
  Closes this dialog and saves the VBScript. The script can also be empty, in which case nothing is executed.

• Cancel
  Closes this dialog without saving. Please note that any changes you have made will be lost.

• Test
  Use this button to execute the script. The entire message is simulated in the background from the beginning, i.e. when the message is loaded and the trigger query is executed, up to the point where the VBScript to be processed is located. This gives you an exact environment with the same conditions as if you were processing the message using the job.

Additional script variables

There are a few other variables that are made available to the VBScript by the program, which you can of course also use. These are the following predefined VBScript variables: