<Source>.StatDate (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 / Managing databases / HFSQL / HFSQL functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Source>.StatDate (Function)

In french: <Source>.StatDate

Available only with these kinds of connection

Returns the date of the last update for the index statistics. These statistics have been calculated with <Source>.StatCalculate or <Source>.Index.

Example

// Réalisation de statistiques sur la clé NomCli du fichier de données Client
Client.StatCalcule(NomCli)

// Connaître la date de réalisation de ces statistiques
ResDate = Client.StatDate()
Info("Les statistiques effectuées sur la rubrique NomCli ont été réalisées le : " + ...
			DateToString(ResDate, maskDateSystem))

Syntax

<Result> = <Source>.StatDate([<Key item>])

<Result>: Character string

Date of the last update performed on the statistics, in YYYYMMDD format (YYYY corresponds to the year, MM to the month and DD the day). The date is returned in UTC format (Universal Time Coordinated).
Empty string ("") if the statistics have not been calculated.

<Source>: Type corresponding to the specified source

Name of the data file used.

<Key item>: Optional character string

Name of the key item on which the statistics have been calculated. If this name is not specified, <Source>.StatDate will use the last key item used by the last HFSQL management function (function starting with "H").

Remarks

In HFSQL data files, statistics can be calculated on key items only.

Component: wd300hf.dll