ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Which date and time will be taken into account?
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
HRecordDate (Function)
In french: HDateEnreg
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Returns the date and time of last write operation performed on a record in an HFSQL data file (Classic or Client/Server).
Example
// Get the date and time of the last modification
// on the current record
Info(HRecordDate(Customer))
Syntax
<Result> = HRecordDate([<Data file> [, <Record number>]])
<Result>: Character string
  • Date and time of the last write operation in YYYYMMDDHHmmSS format. The date and time are expressed in UTC format (Universal Time Coordinated).
  • Empty string ("") if an error occurs or if this feature is not supported by the file.
<Data file>: Optional character string
Name of the data file used.
If this name is not specified, HRecordDate will use the last data file used by the last HFSQL function (function starting with "H").
<Record number>: Optional 8-byte integer
Number of the record used.
If this parameter is not specified, HRecordDate will handle the current record.
Remarks

Which date and time will be taken into account?

The date and time (with one-second accuracy) are taken from the moment HAdd, HModify, HCross, HDelete or any functionality wrote to the data files (automatic modification of data files, import functions, reindexing, implementation of integrity rules, etc.).
Component: wd300hf.dll
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/03/2023

Send a report | Local help