ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Warning
From version 26, LinksLineDetails is kept for backward compatibility. This property has been replaced with RowDetailsBinding.
The RowDetailsBinding property allows you to identify and modify the data binding used to display the details of a row in a Table control based on a data file.
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 Table control based on a data file Hide the details

<Result> = <Table control based on a data file>.RowDetailsBinding
<Result>: Constant or character string
Current binding:
lldNoneNo binding was defined.
No detail is displayed in the Table control based on a data file when clicking the "[+]" sign or when double-clicking the row.
lldAutomaticThe 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 stringThe 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.
<Table control based on a data file>: Control name
Name of the Table control based on a data file to be used.

Modifying the data binding used to display the details of a row in a Table control based on a data file Hide the details

<Table control based on a data file>.RowDetailsBinding = <New value>
<Table control based on a data file>: Control name
Name of the Table control based on a data file to be used.
<New value>: Constant or character string
New binding:
lldNoneNo binding was defined.
No detail is displayed in the Table control based on a data file when clicking the "[+]" sign or when double-clicking the row.
lldAutomaticThe 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 stringThe 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.
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/03/2023

Send a report | Local help