These parameters are specific to adding a "LOOKUP" custom popup menu to the DIALOG window.
Parameter |
Value |
Description |
POPUP_TABLE |
value |
Specifies the table/view name for the pop-up menu. |
POPUP_SELECT |
value
|
Specifies the SELECT clause for the pop-up menu values. e.g. Company, CustState, CustZip |
POPUP_WHERE |
value |
Specifies the WHERE clause for the pop-up menu values. e.g. WHERE CustState = 'PA' ORDER BY Company ASC |
POPUP_DISTINCT |
TRUE FALSE |
Specifies the option to display distinct values for selected columns. |
POPUP_RETURN_COLUMN |
value |
Specifies the column returned. The POPUP_RETURN_COLUMN parameter must be located after your WHERE Clause parameter, if exists, otherwise R:BASE will provide all values specified in your POPUP_SELECT portion of the command. |
POPUP_RETURN_TYPE |
VALUE COLUMN |
Specifies the option to return either the selected item in pop-up menu or the value of POPUP_RETURN_COLUMN. |
POPUP_CAPTION |
value |
Specifies the text for custom pop-up window caption. |
POPUP_TITLE_FONT_NAME |
value |
Specifies the font name for custom pop-up title. |
POPUP_TITLE_FONT_SIZE |
value |
Specifies the font size for custom pop-up title. |
POPUP_TITLE_FONT_COLOR |
value |
Specifies the font color for custom pop-up title. |
POPUP_TITLE_FONT_BOLD |
ON OFF |
Specifies the bold font for custom pop-up title. |
POPUP_TITLE_FONT_ITALIC |
ON OFF |
Specifies the italic font for custom pop-up title. |
POPUP_TITLE_FONT_UNDERLINE |
ON OFF |
Specifies the underline font for custom pop-up title. |
POPUP_TITLE_FONT_STRIKEOUT |
ON OFF |
Specifies the strike out font for custom pop-up title. |
POPUP_TITLE_TEXT |
value |
Specifies the text for custom pop-up title. |
POPUP_TITLE_BACK_COLOR |
value |
Specifies the background color for custom pop-up title. |
POPUP_LIST_FONT_NAME |
value |
Specifies the font name for custom pop-up list items. |
POPUP_LIST_FONT_SIZE |
value |
Specifies the font size for custom pop-up list items. |
POPUP_LIST_FONT_COLOR |
value |
Specifies the font color for custom pop-up list items. |
POPUP_LIST_FONT_BOLD |
ON OFF |
Specifies the bold font for custom pop-up list items. |
POPUP_LIST_FONT_ITALIC |
ON OFF |
Specifies the italic font for custom pop-up list items. |
POPUP_LIST_FONT_UNDERLINE |
ON OFF |
Specifies the underline font for custom pop-up list items. |
POPUP_LIST_FONT_STRIKEOUT |
ON OFF |
Specifies the strike out font for custom pop-up list items. |
POPUP_LIST_BACK_COLOR |
value |
Specifies the background color for custom pop-up list items. |
POPUP_LIST_MULTISELECT |
TRUE FALSE |
Enables the option to select the multiple values within the pop-up list items. |
POPUP_LINES |
value |
Specifies the number of visible lines to be displayed for the list items. |
POPUP_SHOW_LINES |
TRUE FALSE |
Specifies the option to show lines between selected columns for the list items. |
Example:
DIALOG 'Enter Contact to Edit' vContactNo=26 vEndKey 1 +
CAPTION 'Contact Info' +
ICON APP +
OPTION DIALOG_EDIT_HINT 'Double-Click for a List of Contacts' +
|POPUP_ENABLED TRUE +
|POPUP_DIALOG_TYPE LOOKUP +
|POPUP_TITLE_FONT_NAME VERDANA +
|POPUP_TITLE_FONT_SIZE 10 +
|POPUP_TITLE_FONT_BOLD TRUE +
|POPUP_TITLE_FONT_COLOR GREEN +
|POPUP_TITLE_BACK_COLOR WHITE +
|POPUP_TITLE_TEXT 'Select Contact to Edit' +
|POPUP_LIST_FONT_COLOR GREEN +
|POPUP_LIST_BACK_COLOR WHITE +
|POPUP_CAPTION 'List of Contacts' +
|POPUP_TABLE Contact +
|POPUP_SELECT ContFName,ContLName,ContPhone,ContEMail +
|POPUP_RETURN_COLUMN ContID +
|POPUP_WHERE ORDER BY ContFName +
|POPUP_SHOW_LINES TRUE +
|POPUP_RETURN_TYPE COLUMN +
|POPUP_LINES 20 +
|POPUP_DISTINCT TRUE