ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / Managing statistics
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
Returns the date of the last update for the index statistics. These statistics have been calculated with HStatCalculate or HIndex.
Example
// Réalisation de statistiques sur la clé NomCli du fichier de données Client
HStatCalculate(Client, NomCli)
 
// Connaître la date de réalisation de ces statistiques
ResDate = HStatDate()
Info("Les statistiques effectuées sur la rubrique NomCli ont été réalisées le: " + ...
DateToString(ResDate, maskDateSystem))
Syntax
<Result> = HStatDate([<Data file> [, <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.
<Data file>: Optional character string
Name of the data file used. If this name is not specified, HStatDate uses the last data file used by the last HFSQL management function (function starting with "H").
<Key item>: Optional character string
Name of the key item on which the statistics have been calculated. If this name is not specified, HStatDate 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: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help