Advanced Record List Box Control Syntax

Advanced Record List - List Box Control Syntax

Syntax

[%KL=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 - List Box Control provides a dynamic view of selected records and fields from a table or set.

Example

For example, the following script creates a list box 60 characters wide and 10 lines tall with variable width columns. [Picture]

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

Preview mail labels for which customer?;

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

{lf};

<Preview!ok> <Cancel>

%dlg%,<<%b%

if a_dlg_button = "ok" then

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

label.Preview("mail_labels", filter_expression)

end if

%b%)