3—modify row

You can use the Modify row option to change the contents of an existing row of an open table. When you select the Modify row option, perform these tasks on the Tables panel:

Specify the name of a table in the Table Name field. If the table is not open, specify NOWRITE or WRITE in the "Open tables" field.
Specify a row number or a search operand list to identify a row.

Note: Use the View action bar choice on the Tables panel to specify whether this display is to be in a pop-up or full-screen.

When you press Enter, a display that you can scroll (Figure 1) is shown. The pop-up window can also be resized using the RESIZE command.

Figure 1. Modify row panel (ISPYTPM)

 ┌──────────────────────────────── Dialog Test ────────────────────────────────┐
 │   Menu  Utilities  Help                                                     │
 │ ──────────────────────────────────────────────────────────────────────────  │
 │                 Modify row   Table ISPKEYS   row 1        Row 1 to 10 of 74 │
 │                                                                             │
 │ Modify variable values and savenames. Underscores need not be blanked.      │
 │ Enter END command to finalize changes.                                      │
 │                                                                             │
 │       Variable  T A Value                                                   │
 │       KEYLISTN  K   ISPTEST                                                 │
 │       KEY1DEF   N   HELP                                                    │
 │       KEY1LAB   N   Help                                                    │
 │       KEY1ATR   N   SHORT                                                   │
 │       KEY2DEF   N   SPLIT                                                   │
 │       KEY2LAB   N   Split                                                   │
 │       KEY2ATR   N   LONG                                                    │
 │       KEY3DEF   N   EXIT                                                    │
 │       KEY3LAB   N   Exit                                                    │
 │       KEY3ATR   N   SHORT                                                   │
 │                                                                             │
 │ Command ===>                                             Scroll ===> PAGE   │
 │  F1=Help        F2=Split       F3=Exit        F4=Expand      F5=Rfind       │
 │  F6=Resize      F7=Backward    F8=Forward     F9=Swap       F10=Actions     │
 └─────────────────────────────────────────────────────────────────────────────┘

Each line on the panel represents a variable in row 6 of the table and contains a line command field and these fields:

Variable

Variable name, modifiable only for save variables.

T

Type of variable, non-modifiable:

K: Key variable.
N: Name variable; non-key.
S: Save (extension) variable.

A

Attribute of each variable, non-modifiable:

T: Truncated to 2048 characters for display.

Value

Value of the variable, up to 2048 characters.

Type in new values or change the current values for the key, name, and save variables in the Value column. Enter new save variables by typing over the underscores in the Name column with the variable names and specifying the desired values. The underscores are pad characters; you do not need to blank them out.

When using the Modify row option, be aware that:

If the table has keys, the values for the keys in the added row must be different from those in the existing rows when you leave the Modify row option. Otherwise, a message is displayed and the row is displayed again so you can change the keys.
If the table was sorted using the TBSORT dialog service and a sort field is modified, the row's position in the table can change to preserve the search order.
You cannot change the variable name for a key variable or name variable; if you do, an error message is displayed and the original name is restored.
You cannot delete a key or name variable and its value from the display or table row.
If you delete a save variable, assume that the variable no longer exists in this row.
If more than one variable entry has the same name, all instances of that variable are assigned the value of the last occurrence of the variable; that is, the occurrence closest to the bottom of a display that you can scroll.
Blank save names are ignored and do not need to be deleted, even if data is left in the value.
Hexadecimal data that usually cannot be displayed is converted to characters that can be displayed or is typed by using the form:
```
X'nnnnnnnn'
```
where:
n

An integer 0-9 or an alphabetic character A-F. There must be an even number of characters within the quotation marks.
Variables defined with the VDEFINE service as non-character are shown in converted form; do not change them by using the hexadecimal representation. A format or length error causes a message to be displayed when you use the END command.
When you leave the Modify row option by using the END command, the row is replaced, and the message Row modified is issued.