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
Allows you find out the position of the selected cell and to select a cell in a Pivot Table control.
Example
// Récupérer la position courante
tcdPos est un tcdPosition
tcdPos = TCD_Stats.Select()
SI PAS tcdPos.EnDehors ALORS
Trace(tcdPos.Pays + " " + tcdPos.Ville)
FIN
Versions 21 and later
// Browse the selected cells
pvtPos is pvtPosition of PVT_MyPVT
 
nbSel is int = PVT_MyPVT.SelectOccurrence()
FOR i = 1 TO nbSel
pvtPos = PVT_MyPVT.Select(i)
Trace(pvtPos.COL_Today_Date + ":" + pvtPos.COL_Product))
END
New in version 21
// Browse the selected cells
pvtPos is pvtPosition of PVT_MyPVT
 
nbSel is int = PVT_MyPVT.SelectOccurrence()
FOR i = 1 TO nbSel
pvtPos = PVT_MyPVT.Select(i)
Trace(pvtPos.COL_Today_Date + ":" + pvtPos.COL_Product))
END
// Browse the selected cells
pvtPos is pvtPosition of PVT_MyPVT
 
nbSel is int = PVT_MyPVT.SelectOccurrence()
FOR i = 1 TO nbSel
pvtPos = PVT_MyPVT.Select(i)
Trace(pvtPos.COL_Today_Date + ":" + pvtPos.COL_Product))
END
tcdPos est un tcdPosition
// Sélectionner "France / 2014"
tcdPos.Pays = "FRANCE"
tcdPos.Annee = "2014"
TCD_Stats.Select(tcdPos)
Syntax

Retrieving the position of selected cell in a Pivot Table control Hide the details

<Result> = <Pivot Table control>.Select([<Rank>])
<Result>: pvtPosition variable
pvtPosition variable containing the position of selected cell in the control. If no element is selected, the Property Outside of the Variable of type pvtPosition returned is True.
<Pivot Table control>: Control name
Name of Pivot Table control to use.
<Rank>: Optional integer
Versions 21 and later
Rank of selection for a multi-selection control. If this parameter is not specified, the position of first selected cell is returned.
New in version 21
Rank of selection for a multi-selection control. If this parameter is not specified, the position of first selected cell is returned.
Rank of selection for a multi-selection control. If this parameter is not specified, the position of first selected cell is returned.

Selecting a position in a Pivot Table control Hide the details

<Pivot Table control>.Select(<Position> [, <Value>])
<Pivot Table control>: Control name
Name of Pivot Table control to use.
<Position>: pvtPosition variable
Name of the pvtPosition variable corresponding to the position to select. A WLanguage error occurs if the position does not correspond to a visible cell.
<Value>: Character string (with or without quotes)
Name of the value to select. If this parameter is not specified and if several values are found in the same cell, the first value is selected.
Component: wd270obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment