transaction records - fields |
Each transaction record contains the following fields:
Action
Type of action to be performed. The options are as follows:
I = Insert (enter new records into the database)
M = Modify (change one or more fields in one or more records that already exist in the database)
D = Delete (delete records from the database)
Quantity of restrictions
Number of restrictions (items) to specify in the filter dialog box. Specify zero if inserting records; filters do not operate in Insert mode. If modifying or deleting records, specify the exact set of database entries on which the transaction is to operate.
Note: A single update or delete transaction can operate on any number of database entries. For example, to modify a specific field on all equipment records assigned to a department, you need only one transaction and one filter entry for the desired department ID. To update or delete a single database entry, be sure to specify a filter entry (such as an ID) that uniquely refers to that entry.
Filter restrictions (if any)
Specifies which records FASuite should modify or delete (dependent on the value in the Action field). Each restriction consists of a window ID and control-order value, which specify the field to which the restriction value applies and the restriction value itself.
Note: If the value in the Quantity of restrictions field is zero, do not specify filter restrictions. (e.g., when you use the import file to insert database records).
Quantity of controls
Number of data items included in the transaction record, exclusive of data items included in groups (scroll regions).
Field data
One or more data items that consist of a window ID and a control-order value, which specify the field to which the data applies and the data.
Note: You must specify the window ID and control order values for each screen individually.
Quantity of groups
Number of multi-line groups for which data is provided. If the quantity of groups is zero, no additional data appears. If it is a number other than zero, the transaction record also contains data for groups on the screen. Data for all groups on a screen follows all field data that does not relate to groups for all windows of the screen.
Data for each group contains the following fields:
Quantity of rows. Number of rows in the group for which data is provided.
Row data
Row number: Relative number of the row on the screen (starting with 0, not 1).
Quantity of controls: Number of data items included in the row.
Data: One or more data items, consisting of a window ID and a control-order value, which specify the field to which the data applies and the data.
_______________
See Also