The Update component permits the Procedure-generated updating of an existing row of data in any database table shown in the Palette's Resources.

Upon landing in the Workspace, it will be displayed with two areas: a header field to receive the database table name and a body data line (for one field of the database row to be updated) consisting of: Run-time switch + Value (incoming data), Action (Add, Sub, Set) and Set Field (target repository of the incoming data). If more than one data line is required, resize the component.

The Action is inferred from the field data type of the target field i.e. for non-numeric data fields it will be Set or, when an arithmetic operation is a possibility, a pop-up selection button will offer the choices. When using the arithmetic options (Add, Sub) remember the mathematical rules e.g. if you want to sum up a number of positive and negative values, use Add (the negative values will be subtracted as part of the Add process).

Update is usually targeted at a unique row of data which is defined with the Search Criteria of the Inspector.

To specify the database table update, with the resized Update component selected (control points are visible):

• select the desired database table (Palette's Resources - Database), this will load the database name into the component and display, in the Palette, the available fields;
• select the desired target field (Palette's Resources - Field), repeat for each Set Field;
• specify the Value either hard-coded (set run-time switch to white and type data into Value field) or loaded at run-time (set switch to grey and load data source reference into Value field);
• provide the necessary specifications in the Inspector i.e. Search Criteria, if any. Note that if no Search Criteria is specified, the update will be done on ALL rows in the table.
• if the Action is a choice, make the appropriate selection;
• complete additional Field's, if any;
• drag Success? component from Inspector and connect as required (optional).

Caution:

• If the Success? component, located in the Inspector's Error Checking view, is useful to your Procedure, you should attach appropriate actions to the Yes and No exits.
  
• Read up on the use of the Packet option