ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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: A "Timestamp" field cannot be assigned by 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"
UneRubrique.TimestampType = htsCreation
UneRubrique.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 programmatically:
    • 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: 09/30/2024

Send a report | Local help