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

UPDATE ADD

MPE documents

Complete PDF
Table of Contents

E0300 Edition 7 ♥
E1098 Edition 6

Adds data entries to a manual master or detail data set.

Syntax


  {U[PDATE] ADD,
   AD[D]}  [data base name:] data set name
For example: 

  >UPDATE ADD,LABOR
Where data set name = LABOR 

  >AD PAYROLL
Where data set name = PAYROLL

Parameters

data base name

is the name of a data base specified in either the DEFINE, DATA BASE=, or MULTIDB command.

data set name

is the name of a data set in the data base. The data set must be either a manual master or detail. You must have write access as determined by the password you enter in response to the PASSWORD= prompt or through the PASSWORD= command.

Discussion

When you use the UPDATE ADD command, QUERY prompts you for data item values by printing the names of the data items. You type the desired value following the data item name. QUERY will continue to prompt you for data item values until you terminate the command.

In a procedure, you must use the UPDATE ADD form of the command. UPDATE can be abbreviated. ADD cannot be abbreviated when it is used with the UPDATE keyword.

You must have specified mode 1, 3, or 4 to use this command.

Example


  >AD PRODUCT
  STOCK#           =>>12345678
  DESCRIPTION      =>>"ANTIMACASSAR"

  STOCK#           =>>Return
  STOCK#           =>>54231234
  DESCRIPTION      =>>Return

  STOCK#           =>>//
  >
In the example above, the STOCK# is a search item. A value must be provided. Since DESCRIPTION is not a search item, it can be left blank by pressing the RETURN key. However, if you try to use RETURN for a search item, QUERY will prompt you again for the value. The command is terminated with two slashes.

If you are in session mode and enter a value that is too large or that contains invalid characters, QUERY issues an error message and reprompts with the same data item name.

If illegal data is encountered while QUERY is running in a job or from an XEQ file, QUERY will issue an error message and stop adding data. In job mode, QUERY will also terminate.

The UPDATE ADD command will prompt you for each sub-item (each occurrence of a compound data item). If you want to terminate the prompting for sub-items, enter two asterisks (**). QUERY will then prompt you for the next item. 

  >UPDATE ADD,SALES
  SALESPERSON     =>>JONES
  MONTHLY-SALES(1)=>>450
  MONTHLY-SALES(2)=>>700
  MONTHLY-SALES(3)=>>**
  REGION          =>>MIDWEST

  SALESPERSON     =>>//

Using Quotation Marks

Values can be entered with, or without quotation marks. When you enter U or X type values without quotation marks, leading blanks are ignored and the value is left-justified in the data item field. Blanks or any other special characters are entered in the data field only if the value is entered with quotation marks. For example, if F-NAME is a U type data item, then: 

  F-NAME         >>  SALLY
is entered in an 8-character field as: SALLY with no leading blanks 

  F-NAME         >>"  SALLY"
is entered an 8-character field with 2 leading blanks before SALLY.

A U type data item is automatically upshifted if it is entered in lowercase. You can override the upshifting by enclosing the entry in quotation marks. In the next two examples, F-NAME is a U type data value. 

  F-NAME          >>sally
is entered as: 

  SALLY



  F-NAME         >>"sally"
is entered as: 

  sally
If quotation marks are to be included as part of the value to be entered, they must be entered twice to avoid being confused with delimiters. For example, the value: 

  ROBERT "BOB" BRUN
must be entered as: 

  "ROBERT ""BOB"" BRUN"
Numeric type values (all types except U and X) are always right-justified whether entered with or without quotation marks. Numbers entered in X type data items are always left-justified.

Null Values

Only search and sort items must have values supplied. If you do not want to enter a value for other items, you can enter a null value. In session mode press RETURN without any preceding characters. In job mode, supply a blank line to indicate a null value. Numeric data items which do not contain a value are set to zero, character items are set to blanks.

Real Number Values

Real number values can be entered as either fixed or floating point numbers. An example of a fixed point number is: 

  23.45
An example of a floating point number is: 

  2.345E+01
The signed integer following the E stands for a power of 10 to be multiplied by the number to the left of the E. Both examples above stand for the same number.

Detail Data Sets

If a detail data set is linked to one or more manual master data sets, you must know the content of the master set before you can add entries to the detail data set. Each detail entry is associated with a master entry through the same search item. The detail search item and the master search item must have the same value, and the value must exist in a master entry before it can be added to a detail data entry. If you enter a search item value that does not exist in the master data set linked to the detail set through that search item, QUERY prints the following error message: 

  MISSING SEARCH KEY VALUE FOR data item name IN MASTER data set name

  ==========|ENTRY CANNOT BE ADDED|==========

Terminating UPDATE ADD

Once you have supplied values (null or otherwise) for all the data items in the entry, QUERY begins prompting you for another entry. To continue adding entries, merely enter an appropriate value at the prompt. To terminate UPDATE ADD command, either enter two slashes (//) followed by RETURN or enter CONTROL-Y.

The command can be terminated at any time. However, if you want to save the values you have entered for the current entry, do not use the CONTROL-Y or two slashes before you have been prompted for the last value of the current entry. Normally you will terminate the command in response to the first data item prompt in an entry.

Example

In the example below, the user tries to add an account to the SALES detail data set, but the account is not already in the CUSTOMER master data set. QUERY prints an error message and reprompts for data item values. The command is terminated with two slashes. Next, the account is added to the CUSTOMER master data set. The original entry can then be added to the SALES detail data set. Note that dates are automatically added to the DATE-MASTER automatic master data set. 

  >ADD SALES
  ACCOUNT         =>>86110047
  STOCK#          =>>14519990
  QUANTITY        =>>6
  PRICE           =>>2000
  TAX             =>>RETURN
  TOTAL           =>>RETURN
  PURCH-DATE      =>>121585
  DELIV-DATE      =>>121685
  MISSING SEARCH KEY VALUE FOR ACCOUNT IN MASTER CUSTOMER

  ==========|ENTRY CANNOT BE ADDED|===========

  ACCOUNT         =>>//
  >ADD CUSTOMER
  ACCOUNT         =>>86110047
  LAST-NAME       =>>CELERY
  FIRST-NAME      =>>ALLISON
  INITIAL         =>>B.
  STREET-ADDRESS  =>>18 ASCOTT AVE.
  CITY            =>>CARMEL
  STATE           =>>CA
  ZIP             =>>93921
  CREDIT-RATING   =>>1.2

  ACCOUNT         =>>//
  >ADD SALES
  ACCOUNT#        =>>86110047
  STOCK#          =>>141990
  QUANTITY        =>>6
  PRICE           =>>2000
  TAX             =>>RETURN
  TOTAL           =>>RETURN
  PURCH-DATE      =>>121585
  DELIV-DATE      =>>121685

  ACCOUNT         =>>//



UNDO

UPDATE DELETE