Executes an UPDATE command stored as a procedure in the current Proc-file.
Syntax |
 |
U[PDATE] procedure name [,character]
|
For example:
Where procedure name = UPDNAMES
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.
