HStatDate (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HStatDate (Function)

In french: HStatDate

Available only with these kinds of connection

Returns the date of the last update for the index statistics. These statistics have been calculated with HStatCalculate or HIndex.

Versions 18 and later

This function is now available in Windows Store apps mode.

New in version 18

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

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Versions 22 and later

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

New in version 22

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

This function is now available for iPhone/iPad applications.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

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, 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 (with or without quotes)

Name of data file used. If this name is not specified, HStatDate will use the last data file used by the last HFSQL management function (function starting with "H").

<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 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