PVTCalculateUpdate (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions

Calculation mode
When to use PVTCalculateUpdate?

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

PVTCalculateUpdate (Function)

In french: TCDCalculeMiseAJour

Updates some of the data found in a Pivot Table control from a given date.

Remarks:

The contents of the Pivot Table control have been loaded into memory using function PVTLoad.
The Dynamic array field has a column, a row or a date-type display filter.

Example

// Construit le nom du fichier
sFichier = SysDir(srAppData) + ["\"] + "StatsParPays.tcd"

// Le fichier existe ?
IF fFileExist(sFichier) THEN
	// Oui, on le charge 
	PVTLoad(TCD_Statistiques, sFichier)
	// On met à jour le champ Tableau croisé dynamique à partir de la dernière date du calcul
	// (on suppose que les enregistrements associés à une date antérieure
	// n'ont pas été modifiés)
	PVTCalculateUpdate(TCD_Statistiques, LoadParameter(DATE_DERNIER_CALCUL))
ELSE
	// Le fichier n'existe pas, on le calcule
	PVTCalculateAll(TCD_Statistiques)
END

Syntax

PVTCalculateUpdate(<Pivot Table control> [, <Start date>])

<Pivot Table control>: Control name

Name of the Pivot Table control to be used.

<Start date>: Optional character string or Date variable

Date from which the content of the Pivot Table control must be recalculated. This date must be in "YYYYMMDD" format. All the records associated with a Date item whose content corresponds to a date greater than <Start date> will be taken into account.
If this parameter is not specified, the date taken into account corresponds to the maximum date of the last result calculated or read by PVTLoad.

Remarks

Calculation mode

The records used to recalculate the data have the following characteristics:

The records have a Date item.
The content of the Date item is greater than or equal to the value of <Start date>.

Former values in the Pivot Table control (if any) are deleted from <Start date>.

The calculation can take a long time if a lot of data has to be read. In this case, a progress bar is displayed in the control.

Once the calculation is completed, the new Pivot Table is displayed. Then, the result can be saved by PVTSave.

When to use PVTCalculateUpdate?

The function PVTCalculateUpdate function should be used when the data are fixed: for example, invoices. You can only add new invoices. In this case, the recalculation date corresponds to the date on which the content of the Pivot Table control was last saved.

If the data displayed in the Pivot Table control can be modified (quantity, price, etc.), you must:

recalculate the entire Pivot Table control.
recalculate the Pivot Table control from the date on which the record was modified.

Component: wd300obj.dll