PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
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
Deletes all formulas added by TableFormulaAdd.
Example
TableFormulaDeleteAll(TABLE_MaTable)
nLigne is int
nLigne = TableFormulaAdd(TABLE_MaTable.COL_Num, "Moyenne positive", ProcInit, ProcAjout, ProcFin)
// Changement de la couleur de fond de la ligne du calcul personnalisé
COL_Num[nLigne].CouleurFond = LightRed
 
nCompteur is int
INTERNAL PROCÉDURE ProcInit()
nCompteur = 0
RETURN 0
END
 
INTERNAL PROCÉDURE ProcAjout(Accumulateur, ValeurCol)
// Ignore les négatifs ou NULL
IF (ValeurCol <= 0) RETURN Accumulateur
nCompteur++
RETURN Accumulateur + ValeurCol
END
INTERNAL PROCÉDURE ProcFin(Accumulateur)
IF nCompteur = 0 THEN RETURN 0
// Calcul de la moyenne
RETURN  Accumulateur/nCompteur
END
Syntax
TableFormulaDeleteAll(<Table control>)
<Table control>: Control name
Name of the control to be used. This control can correspond to:
  • a Table control.
  • a TreeView Table control.
If this parameter corresponds to an empty string (""), the control to which the current event belongs will be used.
Remarks
The preset calculations (total, mean, count, min, max) are not affected.
Component: wd270obj.dll
Minimum version required
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment