The Update object permits the Procedure-generated updating of an existing row of data* in any database table shown in the Palette's Resources other than a Transaction table i.e. TXDetail or OpenItem.
|*||At the present time, only local fields can be updated by the Update object. Linked fields are disabled in the Fields column of the Palette and cannot be made targets for receiving data. The reason for this is that linked fields do not carry any data in the table; rather, they contain pointers to rows in the source table(s) that feed the data into the linked fields.|
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 object.
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 object selected (control points are visible):
Table of Content