ALTER-TABLE

Function

Manipulates table attributes.

Syntax

ALTER—TABLE
NAME=table_name_var|_lit|_col
ACTION=action_lit
[COUNT=count_var|_lit|_col]
[ROW=row_var|_lit|_col]
[ATTRIBUTES=({keyword1},{value1}, ..., {keywordn},{valuen})]

Arguments

NAME

Name of the table created by CREATE-TABLE.

ACTION

Action to perform on thee table.

When ACTION=ERASE, the underlying table data is removed from memory. When this action is specified, no other keywords can be specified.
When ACTION=INFO, table information will be retrieved as defined. The following keywords are allowed (you must specify at least one):
- ROW–The last table row acted upon.
- COUNT–Number of rows in the table.
When ACTION=ATTRIBUTES, table rows will have all unassigned columns set to the specified attributes. If an attribute is not specified, the current setting is retained. The following keywords are allowed:
- ROW–The row to be affected.
- COUNT–Number of rows. (Default=1)
- ATTRIBUTES–Attributes to apply to the rows.

COUNT

Number of affected rows.

ROW

The insertion row.

ATTRIBUTES

Attributes to apply to the row.

Table 14. ALTER-TABLE Attributes

Attribute	Description
DEFAULT	Causes all attributes to be set to their default values as defined by DECLARE-TABLE and CREATE-TABLE before applying any other attributes.
BACKGROUND	Background color name or RGB triplet
BOLD	YES \| NO
CENTER	YES \| NO
COLUMN-LEADING	Expressed in decipoints
COLUMN-LINE COLOR	Color name or RGB triplet
COLUMN-LINE-THICKNESS	Expressed in decipoints
COLUMN-LINE-STYLE	SOLID \| SQUARE-DOT \| DASH \| DASH-DOT \| LONG-DASH \| LONG-DASH-DOT \| LONG-DASH-DOT-DOT
HEADER	YES \| NO
FILL-COLOR	Fill color name or RGB triplet. Default=NONE
FONT	Font number
FOOTER	YES \| NO
FOREGROUND	Foreground color name or RGB triplet
GROUP-HEADER	YES \| NO
GROUP-FOOTER	YES \| NO
ITALIC	YES \| NO
POINT-SIZE	Point size of the font
ROW-BORDER-COLOR	Color name or RGB triplet
ROW-BORDER-LINE-STYLE	SOLID \| SQUARE-DOT \| DASH \| DASH-DOT \| LONG-DASH \| LONG-DASH-DOT \| LONG-DASH-DOT-DOT
ROW-BORDER-THICKNESS	Expressed in decipoints
ROW-LINE-COLOR	Color name or RGB triple
ROW-LINE-STYLE	SOLID \| SQUARE-DOT \| DASH \| DASH-DOT \| LONG-DASH \| LONG-DASH-DOT \| LONG-DASH-DOT-DOT
ROW-LINE-THICKNESS	Expressed in decipoints
UNDERLINE	YES \| NO
WRAP	YES \| NO \| maximum number of lines
WRAP-HEIGHT	Number of lines between each wrapped line
WRAP-ON	Characters on which to force a WRAP
WRAP-STRIP	Characters to change to a space before the WRAP is done

Description

Use ALTER-TABLE in any section except BEGIN-SETUP, BEGIN-SQL, and BEGIN-DOCUMENT to manipulate table objects.

Example

alter-table name='customers' action='attributes' count=1 row=1
    attributes=('foreground',('green'),'background',('red'),
       'center','no','italic','yes','row-border-color','black',
       'row-border-thickness',4,'fill-color','yellow','point-size',8,
       'bold','yes')