8. Demonstration only Expression to understand TADB Attribute Lists

Procedure

  1. There is one attribute normal group (in the expression), defined as follows.
    Order Card Attributes include A, C.
  2. There is one attribute list group (in the expression), defined as follows.
    Parts Attributes include quantity.

    Query Expression 1

    Order Card.A;Parts.quantity;Order Card.C,3,2

    Where

    Criteria Is/are the:
    A Order card attribute
    quantity List group attribute
    C Order card attribute

    Important: This expression is for demonstration only. It shows how Index numbers are used. However, it is not useful because it fails to display what quantity goes with what part.

    Query Expression says:

    Return values as follows:

    • All the values for A attribute.
    • Quantity of parts in the parts list.
    • C attribute value characters in positions 3 and 4.

    Query Expression Results

    The results come back in a 2-dimensional array with 5 rows.

    • The columns are:
    • A 0 based index in the first column.
    • Returned values in the second column.
    • Five indexed rows correspond to the expression's returned values.

    The results for the above attribute list might look like this:

    0 DFG7 J3356F5CS
    1 45
    1 55
    1 1
    2 G9

    The indexed rows relate to the expression as follows.

    Expression Index Result
    Order Card.A 0 DFG7 J3356F5CS
    Parts.quantity 1 45
    Parts.quantity 1 55
    Parts.quantity 1 1
    Order Card.C,3,2 2 G9

    Quantities are returned for three parts. The results do not tell what the parts are.