Advanced Record List - Edit Combo Box Control Syntax

Syntax

[%KE= Table,{ Keylist_Expression } [ { Filter_Expression } ] % [. Width [, Height ]] Variable_Name [ ! rl_* ][ ? Enabled ] ]

Note : You must not have any space characters in the finished command.

Argument	Type	Description
Table	C	The name of the table supplying the data to be displayed.
Keylist_Expression	C	Defines the order of the data in the record list and the columns in the record list. Uses a special function called KEYLIST_BUILD().
Filter_Expression	C	Optional. Default = all records. Filters the data that is shown in the Keylist_Expression.
Width	N	The width of the control.
Height	N	The height of the control.
Variable_Name	C	The name of a character variable to receive the user selection, or a numeric variable to receive the index value of the selected radio button. The index of the top-most button is 1.
rl_*	C	Optional. See Event Syntax.
Enabled	L	Optional. See Enabled Syntax.

Description

The Record List - Combo Box Control provides a dynamic view of selected records and fields from a table or set.

Example

For example, the following script creates a combo box 30 characters wide: [Picture]

ui_dlg_box("Print Mail Label",<<%dlg%

Preview mail labels for which customer?;

[%k=clients,{keylist_build('1:25,2:25,3:25', customer_id, alltrim(firstname) + ' ' + lastname, phone, city)}%.30key];

{lf};

<Preview!ok> <Cancel>

%dlg%,<<%code%

if a_dlg_button = "ok" then

filter_expression = "customer_id = '" + key + "'"

label.Preview("mail_labels", filter_expression)

end if

%code%)