LinksLineDetails (Property) In french: LiaisonsDétailLigne
..LinksLineDetails is used to find out and modify the file link 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 [+] found before the row or when he double-clicks the row in the Table control.
// Displays the orders when clicking the row displaying the customer TABLE_CUSTOMER..LinksLineDetails = "CUSTOMERID:ORDER.CUSTOMERID"
// Displays the city name when clicking the row displaying the customer TABLE_CUSTOMER..LinksLineDetails = "ZC:CITY.ZC:NAME "
// Displays the orders as well as the city and state when clicking the row displaying a customer TABLE_CUSTOMER..LinksLineDetails = [ CUSTOMERID:ORDER.CUSTOMERID ZC:CITY.ZC:NAME,STATE ]
Syntax
Finding out the file link used to display the details of a row in a browsing Table control Hide the details
<Result> = <Control name>..LinksLineDetails
<Result>: Constant or character string Current link:
| | lldNone | No link was defined. No detail is displayed in the browsing Table control when clicking the "[+]" sign or when double-clicking the row. | lldAutomatic | The links defined in the analysis are used to find the linked data files to display. If several data files are linked in the analysis, the user will be able to choose the file to display in the details via a popup menu. | Character string | The link 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 linked data files that will be displayed in detail,
- ITEMA, ITEMB are the items linked to the ITEM, ITEM2 items in these linked 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
performs a link between the OrderRef item of Table control and the ParamOrderRef item of QRY_OrderLine query. The items displayed in the detailed window are the VISUAL, REF, CAPTION, UNITPRICE, QUANTITY, TOTALBT items of query result. |
<Control name>: Character string (with or without quotes) Name of browsing Table control to use.
Modifying the file link used to display the details of a row in a browsing Table control Hide the details
<Control name>..LinksLineDetails = <New value>
<Control name>: Character string (with or without quotes) Name of browsing Table control to use. <New value>: Constant or character string New link:
| | lldNone | No link was defined. No detail is displayed in the browsing Table control when clicking the "[+]" sign or when double-clicking the row. | lldAutomatic | The links defined in the analysis are used to find the linked data files to display. If several data files are linked in the analysis, the user will be able to choose the file to display in the details via a popup menu. | Character string | The link 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 linked data files that will be displayed in detail,
- ITEMA, ITEMB are the items linked to the ITEM, ITEM2 items in these linked 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
performs a link between the OrderRef item of Table control and the ParamOrderRef item of QRY_OrderLine query. The items displayed in the detailed window are the VISUAL, REF, CAPTION, UNITPRICE, QUANTITY, TOTALBT items of query result. |
This page is also available for…
|
|
|