PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Returns the date of the last update for the index statistics. These statistics have been calculated by HStatCalculate or HIndex.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Calculate the statistics on the CustName key found in Customer data file
HStatCalculate(Customer, CustName)
 
// Find out the date when these statistics were calculated
ResDate = HStatDate()
Info("The statistics performed on the CustName item " + ...
"were calculated on: " + DateToString(ResDate, maskSystemDate))
Syntax
<Result> = HStatDate([<File name> [, <Name of 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.
<File name>: Optional character string (with or without quotes)
Name of data file used. If this name is not specified, HStatDate handles the last data file used by the last function for HFSQL management (starting with the letter H).
<Name of key item>: Optional character string (with or without quotes)
Name of the key item on which the statistics have been calculated. If this name is not specified, HStatDate handles the last key item used by the last function for HFSQL management (starting with the letter H).
Remarks
  • In the HFSQL data files, the calculation of statistics can only be performed on the key items.
  • This function is not available when accessing a database via Remote Access.
Component : wd240hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment