'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. after the query. This is a VB-Script (Visual Basic Script), which can be used to change previously selected data can be changed afterwards. A Postscript, i.e. a script that is executed "afterwards", has the advantage that a query does not have to be changed anymore, i.e. it provides a certain a certain basis of data and can then be adapted individually by means of a programming language. Since one has more possibilities with programming language has more possibilities, data can be programmed after the query, data can still be changed program-controlled. A VBScript is provided with a certain set of variables, which are variables, which enable a database connection to the query data and create a reference to the message.

View

The screen contains in the first place the script editor, which is a line-oriented editor in which the VBScript is entered. Beside the editor there are a number of predefined variables and replacements, which are made available by means of a menu button. Below the VBScript editor there is a splitter, which can be used to adjust the screen size of the of the editor and the rest of the screen. Below that there is a list with all predefined variables that are passed to the VBScript, some of them are not visible because they contain e.g. the database connection. Below this list is the output window, where the result is displayed. is displayed. The result is the content of the table, which is created by the query associated with the script and modified by the script. by the script.

Operation

Operate the elements on the screen as follows as follows:

• script editor
  Enter/edit a VBScript here. On the right left side the line number is displayed in the editor. If you tab, press the Control key and the the Tab key. The Normal Tab key is used used by default to switch between elements in the dialog. dialog. If you type beyond the right or bottom margin, the scrollbar the scrollbar is automatically displayed.

• Variables Defaults
  Here you can find the default variables that are passed to the script as variables to the script. You can adjust the column"Variable value Input" column by clicking on a value in this column with the column with the mouse and edit the value afterwards. In the"Variable Value Output" column, the values of these the script is executed, the values of these variables are displayed.

• Output result
  In this window, which is an embedded browser window, you can see the result of the corresponding database table for which you opened the for which you opened the script dialog. Here you can see in tabular form the content of the database table is displayed. So you can immediately see the adjustments you have made with the VBScript. are immediately visible.

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

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

• Testing
  Use this button to execute the script. In the background, the entire message is executed from the start, that is, when the message is loading the message and executing the trigger query up to the point at which the where the VBScript to be processed is located. is located. This means that you have an exact environment with the same prerequisites as if you were processing the message using the job. would process the message.

Additional Script Variables

There are still some miscellaneous variables that are provided to the VBScript from the program, you can of course use them as well. you can of course also use. These are the following predefined VBScript variables: