PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

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 is replaced by RowDetailsBinding.
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:
lldNoneNo binding was defined.
No detail is displayed in the browsing Table control 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.
<Browsing Table control>: Control name
Name of the browsing Table control to be used.

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 the browsing Table control to be used.
<New value>: Constant or character string
New binding:
lldNoneNo binding was defined.
No detail is displayed in the browsing Table control 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