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. To insert records, specify zero.
Filter restrictions (if any)
Specifies which records should be modified or deleted (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., you are inserting 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 value 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
Transaction records (overview)