|
Working with Update Record Process |
  
|
Working with Update Record Process
|
Working with Update Record Process |
|
Process Purpose
The Update Record process is used to update records from a table of a remote database in a specific Host server.
The remote database profile you create within MCL-Designer V4 is responsible for the direct communication between your MCL-Designer project and a remote database.
Once the project is loaded into a device, that same profile can be used to allow communication between the device and the remote database/host server, via MCL-Net. Therefore, make sure that the connection string of the selected profile includes an OLE DB provider that is compatible with the intended remote database. Ex: If you intend to use an Oracle database, select a remote database profile with the corresponding driver Microsoft OLE DB for Oracle Provider.
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 Update Record process. This properties window includes three tabs - "General", "Query" and "Advanced".
If any subsequent edition is required, double-click the process to open its properties window and enter the necessary modifications.
General tab
Proceed as follows:
Host Name & Data Source |
|
Host Name |
Select a Host profile from the drop-down list or click |
Data Source |
Select the database to be updated from the drop-down list or click |
Data Table |
|
Table Name |
Select the table (included in the previously selected database) to be updated from the drop-down list. |
Fields to Update |
|
DB Field Name column |
Select the table's field(s) to be updated from the drop-down list. |
Value/Variable column |
Enter the fixed value to update in the previously selected table field(s) or click |
Example
|
The selected database ("Inventory") contains 3 tables ("Items", "Locations" and "Warehouses"). The selected table ("Items") will have its "ItemNumber" and "ItemDescription" fields updated.
|
Use the editing icons to the right of the table to move the rows up and down and to delete or add more rows.
Go to the "Query" tab.
Query tab
Proceed as follows:
Where |
|
Where Clause |
Click |
Use the editing icons to the right of the table to move the rows up and down and to delete or add more rows.
Continue to the "Advanced" tab.
Advanced tab
Fill in the following options:
SQL request name (Must be unique) |
|
Name |
Define a unique name for the SQL request. One is always suggested. |
If … Go to |
|
DB Error |
Select a target location from the drop-down or |
Comm Error |
Select a target location from the drop-down or |
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 top of the properties window:
Click it to setup a time out. See To Define a Time Out.
Click it to edit a data file. See Editing a Data File.
Used to test SQL Scripts. See To Test SQL Scripts.
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 operation.
The added process is displayed in the corresponding "Actions" tab or "Process" window.
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.
to create a new one. See 
to add one. See 
and select a variable with that value. You can update a record with up to 26 values at once. See 
to create the appropriate query. See