PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

X
Y
New WINDEV 23 feature!
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
..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.
Example
// 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:
lldNoneNo link was defined.
No detail is displayed in the browsing Table control when clicking the "[+]" sign or when double-clicking the row.
lldAutomaticThe 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 stringThe 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:
lldNoneNo link was defined.
No detail is displayed in the browsing Table control when clicking the "[+]" sign or when double-clicking the row.
lldAutomaticThe 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 stringThe 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.
Minimum required version
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment