Returns the date and time of last write operation performed on a record in an HFSQL data file (Classic or Client/Server).
// 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.).
Limitation
This function is not available when using a database via
Remote Access.