FILL-TABLE

Function

Manipulates table attributes.

Syntax

FILL-TABLE
NAME=table_name_var|_lit|_col
VALUE=value_var|_lit|_col
LOCATION=(row_var|_lit|_col, column_var|_lit[,length_var|_lit])
[ATTRIBUTES=({keyword1},{value1}, ..., {keywordn},{valuen})]

Arguments

NAME

Name of the table created by CREATE-TABLE.

VALUE

Value to insert into the table.

LOCATION

Where to place the data in the table. The row and column elements define where to place the data. The length element, expressed in coordinate units, temporarily overrides the width of the column and allows data to span multiple columns.

ATTRIBUTES

Attributes to apply to the specified location. If an attribute is not specified, the current value as defined by CREATE-TABLE and ALTER-TABLE is used.

Table 41. FILL-TABLE Attributes

Attribute	Description
ANNOTATION	Arbitrary text string associated with the specified location. SQR passes the data to the backend printer driver–it does not validate the data.
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-STYLE	SOLID \| SQUARE-DOT \| DASH \| DASH-DOT \| LONG-DASH \| LONG-DASH-DOT \| LONG-DASH-DOT-DOT
COLUMN-LINE-THICKNESS	Expressed in decipoints
EDIT-MASK	Edit mask or keyword to use
FILL-COLOR	Fill color name or RGB triplet. Default=NONE
FONT	Font number
FOREGROUND	Foreground color name or RGB triplet
FORMULAE	Arbitrary formula associated with the specified location. SQR passes the data to the backend printer driver – it does not validate the data.
ITALIC	YES \| NO
POINT-SIZE	Point size of the font
ROW-LINE-COLOR	Color name or RGB triplet
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
URL	Specifies the hypertext link for the specified location. SQR does not validate the address.
URL-TARGET	Specifies the target within the URL. SQR does not validate the target.
WRAP	YES \| NO \| maximum number of lines
WRAP-HEIGHT	Expressed as the 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 FILL-TABLE in any section except BEGIN-SETUP, BEGIN-SQL, and BEGIN-DOCUMENT to manipulate table attributes.

Example

fill-table
    name='tab2'
    value=$column1
    location=(3,2)
    attributes=('column-line-color',('green'),'row-line-color',
      ('black'),'font',5)