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

FIND procedure

MPE documents

Complete PDF
Table of Contents

E0300 Edition 7 ♥
E1098 Edition 6

Executes a FIND procedure stored in the current Proc-file.

Syntax


  F[IND] procedure name [,character]
For example: 

  >FIND ACCTS
Where procedure name = ACCTS 

  >F USERS,X
Where procedure name = USERS, and character = X

Parameters

procedure name

is the name of a FIND command previously stored as a procedure using the CREATE command. The procedure must exist in the current Proc-file specified with the PROC-FILE = command, or in response to the PROC-FILE prompt of the DEFINE or MULTIDB command.

character

is any printable ASCII character. If character is included in the command, the FIND procedure is listed.

Discussion

QUERY searches the current Proc-file and executes the procedure named in the command. If the Proc-file has not been declared, or the procedure does not exist in the Proc-file, or the procedure is incorrect in some way, you are informed by an error message. If character is included in the command, QUERY prints the procedure on the standard list device before executing it.

If null data values appear in the procedure, QUERY prompts you for the necessary values. If the retrieval requires a serial search of a data set, the following message is returned: 

  USING SERIAL READ
For more information about storing and using FIND procedures, refer to the CREATE command.

Example


  >FIND FINDACCT
  WHAT IS THE VALUE OF - ACCOUNT
  >>54283545
  2 ENTRIES QUALIFIED
  >R ALL,Z


  54283545
  MAYFIELD
  WILLIAM
  
  37 41ST AVE.
  PETALUMA
  CA
  10101
   8.50000


  54283545
  4397D13P
  1
  4590
  276
  0
  121585
  122085
The FINDACCT procedure contains: 

  FIND CHAIN
  CUSTOMER.ACCOUNT,SALES
  ACCOUNT
  IS "" END
In this example, QUERY prompts for the value of ACCOUNT. The REPORT ALL command prints the entry data. The first entry is from the CUSTOMER master data set. The second entry is from the SALES detail data set.



FIND CHAIN

FORM