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
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Returns the time of the last update for the index statistics. These statistics have been calculated with HStatCalculate or HIndex.
Example
// Calculate statistics for the CustomerName key in the Customer data file
HStatCalculate(Customer, CustomerName)

// Get the time the statistics were calculated
ResTime = HStatTime()
Info("The statistics for the CustomerName field were carried out at: " + ...
	TimeToString(ResTime))
Syntax
<Result> = HStatTime([<Data file> [, <Key item>]])
<Result>: Character string
Time in HHMMSS format (HH corresponds to the hours, MM to the minutes and SS to the seconds). The time is returned in UTC format (Universal Time Coordinate).
<Data file>: Optional character string
Name of the data file used. If this name is not specified, HStatTime 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, HStatTime 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
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/30/2024

Send a report | Local help