Show TOC

Transaction Type: Complex Table ChangeLocate this document in the navigation structure

A complex table change transaction allows the user to add or edit a complex table record stored on the Agentry Client. This transaction type is defined to target an object type. It should, at a minimum, contain a property for the key field of the table and the properties to target each field to be modified by the transaction. To allow for the addition of a new record, it should contain one property for each field in a table record.

When a complex table change transaction is applied, the transaction first looks for a record in the complex table whose key field value is equal to the value of the corresponding property in the transaction. If a match is found, the record is updated with the property values of the transaction. If no match is found, a new record is added to the complex table. The indexes of the complex table are then updated to match the new or modified record.

Complex Table Change Transaction Attributes
Following are the attributes for a complex table change transaction.
  • Type: This attribute specifies the type of transaction. For complex table transactions this is set to “Complex Table Change.” This attribute cannot be changed once the transaction has been defined.
  • Object: The Object attribute specifies the type of object the transaction targets. Though primarily intended to change a complex table record, this transaction type must still target an object.
  • Table: The table attribute specifies the complex table the transaction targets and that will be changed when the transaction is applied.
  • Name: This is the identifier for the transaction definition. This value must be unique among all transaction definitions within the same module.
  • Display Name: The display name is the value shown to users for the transaction on the Client. This is normally seen by the user in the Client’s Transmit Screen when an instance of the transaction is sent to the Agentry Server to be processed.
  • Key Property: This attribute specifies the property within the transaction to be treated as the key property. If no change is made to the targeted object, this attribute need not be set.