Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > D > DIALOG > OPTION parameters > Popup Menu

LOOKUP

Scroll Prev Top Next More

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

 

DIALOG_Popup_Lookup