HTML

HTML

You can use this command to output data in HTML format.

The rows and columns that each clause selects produce an intermediate result table that exists only in temporary memory. One after another, the clauses restrict the rows or columns included in the intermediate result table. After R:BASE has processed all the clauses and any UNION operators, the intermediate result table becomes the final result table.

Options

=backcolor
Is currently not supported; it must be set to: =default.

colname
Specifies a 1 to 18 character column name.

=forecolor
Specifies the text color for the data in the column.

=h =w
Specifies height and width parameters. For both, the keywords LEFT, RIGHT, and CENTER can be used. For width, the range is from 0 - 255 pixels. 0 is no width specification. The height is the addition of the following values, one value from each item:

data justification:	0=default, 1=left, 2=center, 3=right
heading justification:	0=default, 4=left, 8=center, 12=right
vertical alignment:	0=default, 16=top, 32=middle, 48=bottom
HTML format flag:	0=no, 64=yes

HTML
Converts the data to HTML code.

'title'
This is the text that appears in the caption at the top of the Web Browser window. Adding 'title' creates the beginning and ending table tag as well as putting the text you enter in the caption. Without 'title', a partial HTML file with the selected data in table row format is generated.

About the SELECT...HTML Command

The SELECT...HTML command is a modification of the SELECT command to output data in HTML format. If a title is specified, a full HTML file will be generated. Otherwise, a partial HTML file with the selected data in table row format will be generated.