These parameters are specific to changing how the CHOOSE list is displayed.
Parameter |
Value |
Description |
VERTICAL_LINES |
ON OFF |
Specifies if vertical lines will be displayed. Use VERTICAL_LINE_BREAKS to define line locations. |
VERTICAL_LINE_BREAKS |
values |
Specifies comma delimited pixel values for the location of the vertical lines (e.g. 150,185, 255) |
TEXT_BREAKS |
values |
Specifies comma delimited character positions for the text breaks in the list to occur (e.g. 36, 112) |
HEADERS |
values |
Specifies a comma delimited list of column headers (e.g. Table Name, Count, Description) |
HORIZONTAL_LINES |
ON OFF |
Specifies if horizontal lines display between list options |
LINE_COLOR |
value |
Specifies the horizontal line color |
ZEBRA_STRIPES |
ON OFF |
Specifies if the zebra stripe colors are displayed |
ZEBRA_ODD_COLOR |
value |
Specifies the zebra stripe color for odd number list items |
ZEBRA_EVEN_COLOR |
value |
Specifies the zebra stripe color for even number list items |
LIST_BACK_COLOR |
value |
Changes the background color of the list area. User can specify the integer value or type one of the predefined values. |
LIST_FONT_NAME |
value |
Specifies a font name in the list area. Values would consist of the fonts available on the computer. |
LIST_FONT_SIZE |
value |
Specifies a font size in the list area. |
LIST_FONT_COLOR |
value |
Changes font color of the list area. User can specify the integer value or type one of the predefined values. |
LIST_BOLD |
ON OFF |
Makes the font in the list area bold style. |
LIST_ITALIC |
ON OFF |
Makes the font in the list area italic style. |
LIST_UNDERLINE |
ON OFF |
Makes the font in the list area underlined. |
LIST_STRIKEOUT |
ON OFF |
Makes the font in the list area strikeout |
Example ("List View" Options):
CHOOSE vTableViewName FROM #VALUES FOR +
((LJS(SYS_TABLE_NAME,35))&LJS(SYS_COMMENT,75)),SYS_TABLE_NAME FROM SYS_TABLES +
WHERE SYS_TABLE_TYPE <> 'SYSTEM TABLE' ORDER BY SYS_TABLE_NAME ASC +
CHKBOX 1 TITLE 'Select Table/View' +
CAPTION 'Tables' LINES 26 FORMATTED +
OPTION TITLE_BACK_COLOR WHITE +
|TITLE_FONT_NAME Segoe UI +
|TITLE_FONT_SIZE 16 +
|TITLE_FONT_COLOR BLACK +
|TITLE_BOLD ON +
|LIST_BACK_COLOR WHITE +
|LIST_FONT_NAME Tahoma +
|LIST_FONT_SIZE 9 +
|LIST_FONT_COLOR NAVY +
|WINDOW_BACK_COLOR WHITE +
|BUTTON_OK_CAPTION &Continue +
|BUTTON_CANCEL_CAPTION C&ancel +
|BUTTONS_SHOW_GLYPH ON +
|LINE_COLOR 3DLIGHT +
|ZEBRA_STRIPES ON +
|ZEBRA_ODD_COLOR 3DLIGHT +
|ZEBRA_EVEN_COLOR WINDOW +
|HORIZONTAL_LINES ON +
|VERTICAL_LINES ON +
|VERTICAL_LINE_BREAKS 150 +
|TEXT_BREAKS 36 +
|HEADERS Table Name,Description
