Recipe Execution Properties

The Recipe Execution properties allow you to define the variables to execute the save, activate and cancel commands for the same Recipe.

To change the Recipe's Execution properties select the object and use the Movicon 'Properties Window'that appears.

To get more details on the Execution properties that are common to both the Recipes and Data Loggers, please refer to the document on "Common Data Logger and Recipe Execution Properties".

Commands executed with Recipes that require a single or double electronic signature validation can be set with this feature in the Variables that have been set in the Recipe's Execution properties. If no variables have been set in these properties, this feature can be set in the Button Objects that execute Recipe commands. For further information, please see the topics on: "Variable Properties - Access Level Properties" and "Draws and Controls Properties - Access Level Properties"

Execute Query Variable

In this edit box you can select a variable from the Movicon Real Time DB to use to perform any queries set for the Recipe. The query to be executed should be contained in the Query Variable.

You can declare the variable any type (bit, byte, word, etc.), since Movicon will execute the query when the value contained in the variable is other than zero. Once the query has been executed, Movicon will reset the variable to the 'zero' value.

The sequence with which the query is executed is as follows:

Set the Excute Query Variable to the value >< 0 when the query is needed.
Movicon will execute the query in the database and will manage the execution status variable being run.
Movicon will set the execution variable value = 0.
Movicon will notify the completion of the query's execution by resetting the status variable = 0.

In order to execute the query successfully, check the execution status of the query being run before executing another.

When a variable is entered in the 'Execute Variable' property, the project will load the values of the data file's first record into the variables associated to the columns when starting up the project in runtime.

Move First Variable

The execution of a query, filter or data order will generate a RecordSet, which is a group of data extracted from the database and kept in the PC's memory. The 'Move First Variable' edit box allows you to select a variable from the Movicon Real Time DB to be used to execute moves to the first record of the generated RecordSet of the selected data.

The extracted values in the RecordSet will be reported to the variables associated to the Database columns at the rising edge of this variable.

For instance, when using the Filter command to filter a group of data from the database, a RecordSet containing the filtered data will be generated in-memory. When the 'Move First Variable' is activated with a value that is other than zero, all the extracted values in the RecordSet relating to the first record will be written in the variables associated to the database columns.

The variable will then be reset to 'zero' value by Movicon once the operation has been executed.

Move Last Variable

The execution of a query, filter or data ordering will generate a RecordSet, which is a group of data extracted from the database and kept in the PC's memory. The 'Move Last Variable' edit box allows you to select a variable from the Movicon Real Time DB to be used to execute moves to the last record of the generated RecordSet of selected data.

The extracted values in the RecordSet will be reported to the variables associated to the Database columns at the rising edge of this variable.

For instance, when using the Filter command to filter a group of data from the database, a RecordSet containing the filtered data will be generated in-memory. When the 'Move Last Variable' is activated with a value that is other than zero, all the extracted values in the RecordSet relating to the last record will be written in the variables associated to the database columns.

The variable will then be reset to the 'zero' value by Movicon once the operation has been executed.

Move Prev Variable

The execution of a query, filter or data ordering will generate a RecordSet, which is a group of data extracted from the database and kept in the PC's memory. The 'Move Prev Variable' edit box allows you to select a variable from the Movicon Real Time DB to be used to execute moves to the record before the current one being used in the eventual RecordSet of selected data.

The extracted values in the RecordSet will be reported to the variables associated to the Database columns at the rising edge of this variable.

For instance, when using the Filter command to filter a group of data from the database, a RecordSet containing the filtered data will be generated in-memory. When the 'Move Last Variable' is activated with a value that is other than zero, all the extracted values in the RecordSet relating to the record before the current one will be written in the variables associated to the database columns.

The variable will then be reset to 'zero' value by Movicon once the operation has been executed.

Move Next Variable

The execution of a query, filter or data order will generate a RecordSet, which is a group of data extracted from the database and kept in the PC's memory. The 'Move Next Variable' edit box allows you to select a variable from the Movicon Real Time DB to be used to execute moves to the record after the current one being used in the eventual RecordSet of selected data (Each record corresponds to a recipe).

The extracted values in the RecordSet will be reported to the variables associated to the Database columns at the rising edge of this variable.

For instance, when using the Filter command to filter a group of data from the database, a RecordSet containing the filtered data will be generated in-memory. When the 'Move Next Variable' is activated with a value that is other than zero, all the extracted values in the RecordSet relating to the record before the current one will be written in the variables associated to the database columns.

The variable will then be reset to 'zero' value by Movicon once the operation has been executed.

Activate Variable

In this edit box you can select a variable from the Movicon Real Time DB to be used to execute the activation command of the selected recipe. The data loaded in the recipe's temporary variables will also be activated in the recipe's actual variables by this command.

The Activation Variable will then be set to 'zero' value by Movicon once the operation has been executed.

Save Variable

Here you can select a Variable from the Movicon Real Time DB to be used to execute the selected recipe's save command. This command will also save the data, which has been loaded in the recipe's temporary variables, in the Database.

The Save Variable will then be set to ' zero' value by Movicon once the operation has been executed.

Delete Variable

Here you can select a Variable from the Movicon Real Time DB to be used to execute the deletion of the selected recipe. This command will also delete the selected recipe from the Database.

The Delete Variable will then be set to ' zero' value by Movicon once the operation has been executed.

ReQuery Variable

Here you can select a variable from the Movicon Real Time DB to be used to execute a refresh of the recipe recordset.

List Recipes Variable

Here you can select a variable from the Movicon Real Time DB to be used to display the list of recipes. When a variable is entered in this field, a ComboBox component will be inserted instead of a simple Display in the Recipe Index field when the screen is created with the Create Recipe Editor command.

Filter Variable

Here you can select a variable from the Movicon Real Time DB to be used to apply a filter to the recipe's data (WHERE clause).

Sort Variable

Here you can select a variable from the Movicon Real Time DB to be used to sort the recipe's data (ORDER BY clause).

Query Variable

Here you can select a variable from the Movicon Real Time DB to be used to run a query in SQL (standard query language) on the data to be selected from the Database.

Read Variable

This field is used to select a Movicon RealTime DB variable to be used to read Recipe values from the field. The values read from the field will be loaded into the Recipe's temporary variables by overwriting the values of the recipe selected through the "Recipe Index" (this is the recipe loaded, for example, by using the recipe selection combo-box found in the screen created the "Create Recipe Screen" wizard command). Once data has been read from the field and updated the temporary variables, they will be recorded on the database when the recipe's save command is used by overwriting the previous values of the Recipe displayed. This command only updates the Recipe's temporary variables. If the Recipe has not been assigned with temporary variables, this command will not have no effect.