HP 3000 Manuals

HP ALLBASE/BRW Reference Manual

Items 

Items provide a single value each time a calculation is performed.  Most
items, of course, are projected from the final access table.  You can
also define your own items, for example, a calculated item is an item
that you define.  You can also use any HP ALLBASE/BRW standard items.

Characteristics 

All items have these characteristics: 

   *   Items have a single value per record.  That is, on every record,
       or detail line, an item can have only one value.  The value of an
       item can, of course, change with the next record.

   *   Items are referenced by the item name, for example:

            CUSTOMER-NAME

   *   If an item name is not unique, for example, if an item with the
       same name appears in more than one source table, it can be
       preceded by the source table name (without owner name if it is an
       HP ALLBASE/SQL table), followed by a period.  The following
       example shows item DUE-DATE from source table INVOICES.

            INVOICES.DUE-DATE

   *   Standard items can be explicitly specified as shown in this
       example:

            STANDARD.DATE

       which is the standard item DATE.

Related Sections 

   *   Standard Items

   *   Arrays and Array Items

MPE/iX 5.0 Documentation