ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
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
The TimestampType property is used to:
  • Find out the type of timestamp for an item. This item was defined in the data model editor or programmatically.
  • Define the type of timestamp for a Date, Time or DateTime item (when describing the item through programming).
Reminder: You cannot assign a value to a "Timestamp" item through programming. The date the record was created or last changed will automatically be assigned to it.
Example
AFile is File Description
AnItem is Item Description
AnItem.Name = "CmdDate"
AnItem.TimestampType = htsCreation
AnItem.TimestampUTC = False
HDescribeItem(AFile, AnItem)
Syntax

Find out the type of timestamp for an item Hide the details

<Result> = <Data file>.<Item>.TimestampType
<Result>: Integer constant
Type ot timestamp for the item:
htsCreationTimestamp when creating the record only.
htsLastModificationTimestamp whenever modifying the record.
htsNoneNo timestamp.
<Data file>: Character string
Name of the data file used.
<Item>: Character string
Name of item used.
Reports and Queries

Defining the type of timestamp for a Date, Time or DateTime item Hide the details

<Item>.TimestampType = <Type of timestamp>
<Item>: Character string
Name of the item used. This name is defined with the Item Description type.
<Type of timestamp>: Integer constant
Type ot timestamp for the item:
htsCreationThe item is a timestamp item filled when creating the record only.
htsLastModificationThe item is a timestamp item filled whenever modifying the record.
htsNoneThe item is not a timestamp item.
Remarks
  • In the data model editor, you have the ability to define a Timestamp item.
  • To define a Timestamp item through programming:
    • The item must be a DateTime, Date or Time item,
    • the timestamp type is specified with the TimestampType property.
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/03/2024

Send a report | Local help