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
// Get the current position
pvtPos is pvtPosition
pvtPos = PVT_Stats.Select()
IF NOT pvtPos.Out THEN
Trace(pvtPos.Country + " " + pvtPos.City)
END
Versions 21 and later
// Parcours des cellules sélectionnées
tcdPos est un tcdPosition de TCD_MonTCD
 
nbSel est un entier = TCD_MonTCD.SelectOccurrence()
POUR i = 1 À nbSel
tcdPos = TCD_MonTCD.Select(i)
Trace(tcdPos.COL_Date_Jour + ":" + tcdPos.COL_Produit))
FIN
New in version 21
// Parcours des cellules sélectionnées
tcdPos est un tcdPosition de TCD_MonTCD
 
nbSel est un entier = TCD_MonTCD.SelectOccurrence()
POUR i = 1 À nbSel
tcdPos = TCD_MonTCD.Select(i)
Trace(tcdPos.COL_Date_Jour + ":" + tcdPos.COL_Produit))
FIN
// Parcours des cellules sélectionnées
tcdPos est un tcdPosition de TCD_MonTCD
 
nbSel est un entier = TCD_MonTCD.SelectOccurrence()
POUR i = 1 À nbSel
tcdPos = TCD_MonTCD.Select(i)
Trace(tcdPos.COL_Date_Jour + ":" + tcdPos.COL_Produit))
FIN
pvtPos is pvtPosition
// Select "France / 2014"
pvtPos.Country = "FRANCE"
pvtPos.Year = "2014"
PVT_Stats.Select(pvtPos)
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 Out property of the pvtPosition variable returned is set to True.
<Pivot Table control>: Control name
Name of the Pivot Table control to be used.
<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 the Pivot Table control to be used.
<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
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