HPlogo QUERY/iX Reference Manual > Chapter 6 QUERY/iX COMMANDS (cont)

UPDATE procedure

MPE documents

Complete PDF
Table of Contents

E0300 Edition 7 ♥
E1098 Edition 6

Executes an UPDATE command stored as a procedure in the current Proc-file.

Syntax


  U[PDATE] procedure name [,character]
For example: 

  >UPDATE UPDNAMES
Where procedure name = UPDNAMES 

  >U CHANGE,%
Where procedure name = CHANGE and character = %

Parameters

procedure name

is the name of an UPDATE ADD, UPDATE REPLACE, or UPDATE DELETE command procedure in the current Proc-file.

character

is any printable ASCII character.

Discussion

You can use the CREATE command to store any of the three forms of the UPDATE command. Once the procedure is stored in the Proc-file, you use this form of the UPDATE command to execute it. Refer to the CREATE command for information on creating a procedure.

When you execute the UPDATE procedure, QUERY first checks each line of the procedure. If an error occurs, a message is sent and the incorrect statement in the line is ignored. All other correct statements in the procedure are executed. If the character is included in the command, the procedure is listed before the execution begins.

Example


  >>F LAST-NAME IS MAYFIELD
  USING SERIAL READ
  1 ENTRIES QUALIFIED
  >PROC-FILE  =PROCX
  >UPDATE CHANGE
  WHAT IS THE VALUE OF THE CITY
  >>PETALUMA
  WHAT IS THE VALUE OF THE STREET-ADDRESS
  >>37 41ST AVE.
  WHAT IS THE VALUE OF THE CREDIT RATING
  >>8.5
In this example, the FIND command is used to locate the entry to be updated. The procedure named CHANGE (located in Proc-file PROCX) contains the following: 

  U REPLACE,
  CITY="";
  STREET-ADDRESS="";
  CREDIT-RATING="";
  END
When using null values, QUERY prompts for values when the procedure is executed.



UPDATE REPLACE

VERSION