PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | French EN
New WINDEV, WEBDEV and 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 date of the last update for the index statistics. These statistics have been calculated with <Source>.StatCalculate or <Source>.Index.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Versions 22 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
iPhone/iPad This function is now available for iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for the Java applications.
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
ResDate = Customer.StatDate()
Info("The statistics performed on the CustName item " + ...
"were calculated on: " + 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 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>.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.
  • 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