How to Work with Processes > Working with the Data File Processes Group

Process Purpose

The File Update Record process is used to update the values of an existing record in a specific data file.

When you add a process, you are required to define its settings. This occurs in the process's properties window which is displayed automatically after having added the File Update Record process.

If any subsequent edition is required, double-click the process to open its properties window and enter the necessary modifications.

Proceed as follows:

File
File Name	Select the desired file from the drop-down list. This automatically fills in the “Fields” column in the “Fields to Update” table. If necessary, click to edit the selected data file. See Editing a Data File.
	This button only becomes active after a data file has been selected. It opens a "Condition" window with the purpose of specifying which record(s) to update. See Detail of the "Condition" window.
Fields to Update
Field column	This column automatically displays the fields included in the selected data file.
Data Value column	Click to select the variable that will be used to update the field.
If … Go to
Record Found	Select a target location from the drop-down or the list, in case of “Record Found”. See Detail of a window below.
Not Found	Select a target location from the drop-down or the list, in case a record is “Not Found”. See Detail of a window below.
Error	Select a destination from the drop down list or the list, in case an error occurs during the update of a record operation. See Detail of a window below.

Detail of a window:

"S:Menu" is a screen included in the same program as the process.

"R:Routine_1" is a routine included in the same program as the process.

If required, use the icons on the upper right corner of the process properties window:

Click this icon to create a new data file. Go to Creating a Data File to see how to fill in the several options available.

Use the icon to attach any relevant notes to this process. Click it and enter your notes in the resulting text box. These notes will be displayed in the corresponding "Actions" tab or "Process" window (in the "Notes" field) and in the "Developer Report".

After filling in the required options, click to conclude or to abort the setting up of the Update Record process.

The added process is displayed in the corresponding "Actions" tab or "Process" window.

Detail of the Condition window

Fill in the following options:

Conditions
Search Criteria	Select the search criteria from the drop-down list. If the selected option is “Record Number”, the “Record #” box will activate.
Record Number	This option is enabled if the selected search criteria is “Record Number”. Define the number of the record to be read or click and select a variable with the intended value. Before defining "record number" as a search criteria, consider the number of records involved - it may have a performance impact, in terms of speed. To improve performance, we recommend a data look up based on field values (ex: "Search criteria" - "first record" / "Where Field Name" - X /"Equal Value" - Y).
Conditions
Where Field Name column	Specify the field name that will be used to match the search criteria through a "Where" condition from the drop-down list.
Equal Value column	Define the value to be searched. Enter it or click to select a variable with the intended value.
Partial column	Check the “Partial” option if the purpose is to include a partial string value to be searched and not just the complete string value with the "Where" condition.
If record found, store record number into variable
Click to select the variable that will receive the number of the record found (pointer).

Click to apply the options that were filled in and go back to the "File Update Record" window to finish the setting up of the process.

Use the editing icons to the right of each table (in the "Condition" or the "File Update Record" windows) to move the rows up and down and to delete or add more rows.

You can use relative paths to refer the file(s) you want to use in your project. See Working with Aliases.

Use the right click in MCL-Designer's input boxes to access certain features regarding the input box's option as well as general actions such as "Copy"; "Paste"; "Search".

Ex: If you right-click the "Variable" input box (included in a "Conversion's" properties window), you are provided with the "Search..."and "Variable Select" options.

If you right-click another input box, it will provide other possibilities.