HRecordDate (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

Which date and time will be taken into account?

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HRecordDate (Function)

In french: HDateEnreg

Available only with these kinds of connection

Returns the date and time of last write operation performed on a record in an HFSQL table (Classic or Client/Server).

Example

// Get the date and time of the last modification
// on the current record
Info(HRecordDate(Customer))

Syntax

<Result> = HRecordDate([<Table> [, <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.

<Table>: Optional character string

Name of the table used.
If this name is not specified, HRecordDate will use the last table 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 tables (automatic modification of tables, import functions, reindexing, implementation of integrity rules, etc.).

Component: wd310hf.dll