ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

<ftpConnection variable>.Date (Function)
Returns the different dates of a file (date the file was created, modified or accessed) located on an FTP server (File Transfer Protocol).
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
Date and Time functions
List of functions for managing dates and times
The Date input field: Input or display masks
WINDEV, WINDEV Mobile and WEBDEV propose two types of masks...
<Source>.StatDate (Function)
Returns the date of the last update for the index statistics.
DateToDayOfYear (Function)
Returns the day of the year corresponding to a given date.
The formatted display control
This control can be used to display dates, times and monetary values for example, respecting the corresponding display format...
SchedulerDateVisible (Function)
Makes a day visible or invisible in a Scheduler control.
DateToDayOfWeek (Function)
Returns the day of the week that corresponds to a given date.
WeekToDate (Function)
Returns the date of the Monday for the specified week and year.
FirstDayOfYear (Function)
Returns the date of the first day of the year.
LastDayOfMonth (Function)
Returns the date of the last day for the specified month.
OrganizerDateVisible (Function)
Makes a day visible or invisible in an Organizer control.
<Organizer>.DateVisible (Function)
Makes a day visible or invisible in an Organizer control.
DayOfYearToDate (Function)
Takes the number of a day in the year and returns the corresponding date in "YYYYMMDD" format.
MonthNumberInAlpha (Function)
Returns the name of the month according to its number.
Functions for managing Dates and Times (prefix syntax)
List of functions for managing dates and times
<Scheduler>.DateVisible (Function)
Makes a day visible or invisible in a Scheduler control.
HRecordDate (Function)
Returns the date and time of last write operation performed on a record in an HFSQL data file (Classic or Client/Server).
HStatDate (Function)
Returns the date of the last update for the index statistics.
DatePicker (Function)
Opens the system date picker.
Analysis editor: the different types of sections
The different types of items proposed in the data model editor are as follows:
DayNumberInAlpha (Function)
Returns the name of the day of the week according to its number.
DateToDay (Function)
Returns the day corresponding to a given date.
Edit control
The Edit control allows users to enter data...
<Source>.RecordDate (Function)
Returns the date and time of last write operation performed on a record in an HFSQL data file (Classic or Client/Server).
Reports
A report provides a custom view of data......
Native PostgreSQL Connector: Programming with SQL functions
You can use SQL functions to handle the PostgreSQL database......
Native MariaDB Connector: Programming with SQL functions
The SQL functions can be used to handle the MariaDB database......
Native MySQL Connector: Programming with SQL functions
The SQL functions can be used to handle the MySQL database......
5. HFSQL Client/Server
A WINDEV Mobile application can also use an HFSQL database in Client/Server mode....
5. HFSQL Cient/Server
13. Security benefit: managing the "Back" button
Converting an HFSQL Classic database into HFSQL Client/Server
There are two methods to convert HFSQL Classic databases to HFSQL Client/Server in WINDEV, WEBDEV...
Native DB2 Connector : Programming with SQL functions
The use of SQL functions to handle DB2 data does not require importing the file structure...
Compression (Property)
The Compression property is used to manage data compression during a connection (HFSQL...
JSONExecuteExternal (Function)
Calls an external server URL that returns data in JSON format (JavaScript Object Notation).
H.TemporaryDirectory (Variable)
Allows you to force the directory used to store the temporary files when reindexing the HFSQL data...
Screen,Column (External language)
Returns the index of the current column in a Table based on a data file or in a Table populated...
hFileParameter (Type of variable)
The hFileParameter type is used to define the data files taken into account by a scheduled...
Adding files into a replication (ReplicEdit)
When the replication is described, the data files must be added into the replication......
PVTCollapse (Function)
Collapses the data found in a Pivot Table control according to a row header or to a column header.
PVTExpand (Function)
Expands the data found in a Pivot Table control according to a row header or to a column header.
HCheckUnaltered (Function)
Checks whether one or all records in an unalterable data file have not been modified...
RandomCryptoBuffer (Function)
Returns a buffer to the specified size filled with random data, that can be used...
<Pivot table>.Expand (Function)
Expands the data found in a Pivot Table control according to a row header or to a column header.
<Pivot table>.Collapse (Function)
Collapses the data found in a Pivot Table control according to a row header or to a column header.
<Chart>.Rotation (Function)
Turns a Surface or Pyramid chart around one of its axes in order to better view the data
HRecordToString (Function)
Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
MandatoryInput (Property)
... the required data input.
InvalidInputDetect (Function)
Detects and signals an error on required controls left empty and/or controls with invalid data....