HPlogo QUERY/iX Reference Manual > Chapter 3 QUERY/iX COMMANDS

FIND CHAIN

MPE documents

Complete PDF
Table of Contents

E0300 Edition 7 ♥
E1098 Edition 6

Locates data entries from a detail data set and one or more of its corresponding master data sets.

Syntax


  F[IND] CHAIN [#LIMIT=i;] item identifier {IS | IE | EQ | =} "value"
    [{AND | OR} item identifier {IS | IE | EQ |=} "value" ] ... [END]
For example: 

  >F CHAIN EMPLOYEE.BADGE#,LABOR.BADGE# IS "1234" OR&
  >>    EMPLOYEE.BADGE#,LABOR.BADGE# IS "9018"
Where item identifier = EMPLOYEE.BADGE#,LABOR.BADGE#, and "value" = "1234" or "9018" 

  >FIND CHAIN EMPLOYEE.BADGE#,LABOR.BADGE# IE "1234"

  text
  Where master set name = EMPLOYEE, master search item = BADGE#,
        detail set name = LABOR, detail search item = BADGE#,
        value = "1234"

Parameters

i

is an integer specifying the maximum number of qualifying entries you want to retrieve. i must be >= 0. If you specify a negative number, QUERY ignores your input. When the #LIMIT = parameter is specified, only the first qualified entries are placed in the select file. If fewer than i entries exist, all entries that qualify are placed in the select file.

item identifier

takes the form: 


  master set name. master search item
    or
  detail set name. detail search item
master set name is the name of a master data set in the data base.

master search item is the name of a data item defined as the search item for the master data set.

detail set name is the name of a detail data set that is associated with the master data set previously named.

detail search item is the name of a data item defined as a search item for the detail data set. This search item must provide the link between the detail set and the previously defined master set.

value

value is a data item value. It must be the same type and within the same value range as the master search item and detail search item of the data item. Value must be enclosed in quotation marks only if it contains special characters or blanks. Null values may be used. Refer to "Using Null Values" under the FIND command. Value must be an exact match for character type data items (type U or X).

END

must be included in a procedure.

Discussion

Only one detail data set can be accessed using a FIND CHAIN command, but multiple master sets can be used if they relate to the same detail data set through search items.

The data base administrator can provide you with the information required to use this command, or you can use the FORM command to determine the data item and data set relations.

When you enter FIND CHAIN, QUERY searches the specified master data sets for an entry containing the specified search item value. Then QUERY searches the specified detail data set for entries containing the same search item value. Detail entries with the same search item value are called chains. The effect of FIND CHAIN is to locate all the members of a detail chain and the master data entry which constitutes the chain head. For more information on chains, chain heads, and data set relations, consult the TurboIMAGE/XL Database Management System Reference Manual.

When using the FIND CHAIN command:

  • Only selection on the basis of equality may be made. Relational operators other than IS, IE, EQ, and = are not allowed.

  • Only one value per relational operator is allowed.

  • Data items named in the command must always be search items (as defined in the data base).

  • Up to 50 logical connectors (AND, OR) can appear in the same command. Refer to the FIND command for more information about logical connectors.

  • No more than 16 values can be used in each FIND CHAIN command.

Example

In the example below, CUSTOMER is searched for an entry containing ACCOUNT equal to 76623455, and one entry is found. Then PRODUCT is searched for an entry containing a STOCK# equal to 6550D22S, and one entry is found. Then SALES is searched for entries with both ACCOUNT equal to 76623455 and STOCK# equal to 6550D22S, but no entries are located. CUSTOMER is searched for entries containing ACCOUNT equal to 54283545 and SALES is searched for entries containing ACCOUNT equal to 54283545. One entry is found for each relation. Note that both STOCK# and ACCOUNT are search items. 

  >FIND CHAIN CUSTOMER.ACCOUNT,SALES.ACCOUNT IS 76623455 AND&
  >>    PRODUCT.STOCK#,SALES.STOCK# IS 6550D22S OR&
  >>    CUSTOMER.ACCOUNT,SALES.ACCOUNT IS 54283545
  4  ENTRIES QUALIFIED
  >R ALL

  ACCOUNT          =76623455
  LAST-NAME        =MCFALL
  FIRST-NAME       =JEFFREY
  INITIAL          =X
  STREET-ADDRESS   =6650 MONTEREY ROAD
  CITY             =CARMEL
  STATE            =CA
  ZIP              =93921
  CREDIT-RATING    =3.20000

  STOCK#           =6550D22S
  DESCRIPTION      =BASEBALL BAT


  ACCOUNT          =54283545
  LAST-NAME        =MAYFIELD
  FIRST-NAME       =WILLIAM
  INITIAL          =
  STREET-ADDRESS   =39 41ST AVE.
  CITY             =PETALUMA
  STATE            =CA
  ZIP              =10101
  CREDIT-RATING    =8.50000


  ACCOUNT          =54283545
  STOCK#           =4397D13P
  QUANTITY         =1
  PRICE            =4590
  TAX              =276
  TOTAL            =0
  PURCH-DATE       =121585
  DELIV-DATE       =121685



FIND ALL

FIND procedure