RowDetailsBinding (Property)

The RowDetailsBinding property allows you to identify and modify the data binding used to display the details of a row in a browsing Table control.

Reminder: The row details are a "sub-table" displayed below the row when the user clicks the [+] icon next the row or double-clicks the row in the Table control.

Example

// Displays the orders when clicking the row displaying the customer
TABLE_CUSTOMER.RowDetailsBinding = "CUSTOMERID:ORDER.CUSTOMERID"

// Displays the city name when clicking the row displaying the customer
TABLE_CUSTOMER.RowDetailsBinding = "ZC:CITY.ZC:NAME "

// Displays the orders as well as the city and state when clicking the row displaying a customer
TABLE_CUSTOMER.RowDetailsBinding = [
CUSTOMERID:ORDER.CUSTOMERID
ZC:CITY.ZC:NAME,STATE
]

Syntax

Identifying the data binding used to display the details of a row in a browsing Table control Hide the details

<Result> = <Browsing Table control>.RowDetailsBinding

<Result>: Constant or character string

Current binding:
lldNone No binding was defined.
No detail is displayed in the browsing Table control when clicking the "[+]" sign or when double-clicking the row.
lldAutomatic The bindings defined in the analysis are used to find the bound data files to display.
If several data files are bound in the analysis, the user will be able to choose the file to display in the details via a context menu.
Character string The binding is customized. The detailed window displays the specified data.
This string has the following format:

ITEM:FILEA.ITEMA:DispItem1,DispItem2,DispItem3<CR>
ITEM2:FILEB.ITEMB

where:
ITEM,ITEM2 are the items found in the main search file of Table control,
FILEA,FILEB are the bound data files that will be displayed in detail,
ITEMA, ITEMB are the items bound to the ITEM, ITEM2 items in these files,
DispItem1, DispItem2, DispItem3 are the items found in FILEA that will be displayed in detail. If this element is not filled, all visible analysis items will be displayed.
For example, the line:

OrderRef:QRY_OrderLine.ParamOrderRef:VISUAL,REF,
CAPTION,UNITPRICE,QUANTITY,TOTALBT

binds the OrderRef item in the Table control to the ParamOrderRef item in the QRY_OrderLine query.
The items displayed in the detailed window are the VISUAL, REF, CAPTION, UNITPRICE, QUANTITY, TOTALBT items of query result.

<Browsing Table control>: Control name

Name of browsing Table control to use.

Modifying the data binding used to display the details of a row in a browsing Table control Hide the details

<Browsing Table control>.RowDetailsBinding = <New value>

<Browsing Table control>: Control name

Name of browsing Table control to use.

<New value>: Constant or character string

New binding:
lldNone No binding was defined.
No detail is displayed in the browsing Table control when clicking the "[+]" sign or when double-clicking the row.
lldAutomatic The bindings defined in the analysis are used to find the bound data files to display.
If several data files are bound in the analysis, the user will be able to choose the file to display in the details via a context menu.
Character string The binding is customized. The detailed window displays the specified data.
This string has the following format:

ITEM:FILEA.ITEMA:DispItem1,DispItem2,DispItem3<CR>
ITEM2:FILEB.ITEMB

where:
ITEM,ITEM2 are the items found in the main search file of Table control,
FILEA,FILEB are the bound data files that will be displayed in detail,
ITEMA, ITEMB are the items bound to the ITEM, ITEM2 items in these files,
DispItem1, DispItem2, DispItem3 are the items found in FILEA that will be displayed in detail. If this element is not filled, all visible analysis items will be displayed.
For example, the line:

OrderRef:QRY_OrderLine.ParamOrderRef:VISUAL,REF,
CAPTION,UNITPRICE,QUANTITY,TOTALBT

binds the OrderRef item in the Table control to the ParamOrderRef item in the QRY_OrderLine query.
The items displayed in the detailed window are the VISUAL, REF, CAPTION, UNITPRICE, QUANTITY, TOTALBT items of query result.