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

FIND ALL

MPE documents

Complete PDF
Table of Contents

E0300 Edition 7 ♥
E1098 Edition 6

Locates all entries in the data set regardless of the value of the data item specified.

Syntax


  F[IND] ALL [#LIMIT=i;] item identifier
For example: 

  >FIND ALL LABOR.BADGE#
Where item identifier = LABOR.BADGE# 

  >F ALL F-NAME
Where item identifier = F-NAME

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 qualifying entries exist, then all entries that qualify are placed in the select file.

item identifier

takes the form: 


  [data base name:] [data set name.] data item name
data base name is the name of a data base specified in the last DEFINE, DATA-BASE=, or MULTIDB command.

data set name is the name of the data set you want to access.

data item name is the name of any data item in that set.

Discussion

If you want to locate all entries in a data set (and use these entries in a report, for example), this is an easy way to do so.

If you do not specify data set name, QUERY will check the data set list and follow the same rules as defined when using a FIND command with a single data set. (Refer to the FIND command for more information.)

Example


  >F ALL CUSTOMER.ACCOUNT
  USING SERIAL READ
  13 ENTRIES QUALIFIED
  >R D,ACCOUNT,8;END

  54283540
  54283545
  10293847
     .
     .
     .
  24536173
  24566356
  10034765
  >FIND ALL LAST-NAME
  USING SERIAL READ
  13 ENTRIES QUALIFIED
Both FIND commands locate entries in the CUSTOMER data set. The REPORT command prints the value of ACCOUNT for each entry.



FIND

FIND CHAIN