ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Automatic data modification
  • Overview
  • From WINDEV 7 and WEBDEV 7 version 149
  • How will the automatic data modification operate?
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
Automatic data file modification: new date format
HFSQL ClassicAvailable only with this kind of connection
Overview

From WINDEV 7 and WEBDEV 7 version 149

From now on, the following formats are available for the dates and times stored in items:
Format available for the items
Description
Date in YYYYMMDD formatDate format available in WINDEV 5.5, WINDEV 7.5 and later versions.
Date and TimeNew date format, used to store both the date and the time: YYYYMMDDHHmmSSCCC (accuracy: Thousandths of a second)
DurationNew format, used to manage the durations: +DHHMMSSCCC (accuracy: Thousandths of a second)
Time in HHMM formatTime format available in WINDEV 5.5, WINDEV 7.5 and later versions.
How will the automatic data modification operate?
WINDEVWEBDEV - Server codeWindows

Conversion table when going from the "old format" to a new format during the automatic modification of data files.
New formatTimeDateDate/TimeDurationString /
Binary /
Memo
Numeric and currency
Old format
TimeX0Date/Time
The time is initialized with the value
The date is initialized to 00/00/00 (invalid date)
DurationString0
Date0XDate/Time
The time is initialized to 00: 00
The date is initialized with the value
0String0
Date/TimeTimeDateX0String0
DurationTime0Date/Time
The time is initialized with the value
The date is initialized to 00/00/00 (invalid date)
XString0
String/Binary/MemoTimeDate00XLanguage conversion
Numeric and currency00DurationStringX

Remark: For a network setup, the automatic data modification modifies both the data files found on the server and the data files found on the user computers.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/13/2023

Send a report | Local help