PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
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 time of the last update for the index statistics. These statistics have been calculated with <Source>.StatCalculate or <Source>.Index.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Calculate the statistics on the CustName key found in Customer data file
Customer.StatCalculate(CustName)

// Find out the date when these statistics were calculated
ResTime = Customer.StatTime()
Info("The statistics performed on the CustName item " + ...
"were calculated at: " + ...
TimeToString(ResTime))
Syntax
<Result> = <Source>.StatTime([<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).
<Source>: Type corresponding to the specified source
Name of data file used.
<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, <Source>.StatTime 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.
  • This function is not available when accessing a database via Remote Access.
Component : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment