ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

Notifications of an HFSQL server
A server may encounter problems without any user (or developer) noticing anything.
For example:
  • a scheduled task may fail,
  • an automatic backup may fail,
  • a node may become inactive in an HFSQL cluster, ...
Docker image of the HFSQL server
A Docker container with the HFSQL server is available on Docker Hub...
HOperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
HServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
<Connection variable>.ServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
Installing an HFSQL Client/Server server with an application
When creating the setup program of a WINDEV application using HFSQL Client/Server data files, the wizard allows you to...
HManageServerUpdate (Function)
Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates.
HStartServerUpdate (Function)
Used to immediately start the automatic server update.
<Connection variable>.StartServerUpdate (Function)
Used to immediately start the automatic server update.
<Connection variable>.OperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
InStoredProcedureMode (Function)
Indicates whether the code is run on an HFSQL server.
<Connection variable>.ManageServerUpdate (Function)
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates.
HFSQL and Docker
Docker is a software platform that allows you to run applications in software containers on Linux (Docker runs like a daemon)...
HListServer (Function)
Lists the HFSQL servers installed on a computer.
Millisecond (Property)
The Millisecond property is used to: Retrieve the number of milliseconds from a Time, DateTime or Duration variable. Modify the number of milliseconds in a Time, DateTime or Duration variable. Retrieve the milliseconds or the number of milliseconds from a Date item (in "Date and Time" or "Duration" format) Modify the milliseconds or number of milliseconds in a Date item ("Date and Time" or "Duration" format)...
Second (Property)
The Second property is used to: Retrieve the number of seconds from a Time, DateTime or Duration variable. Modify the number of seconds in a Time, DateTime or Duration variable. Retrieve the seconds or the number of seconds from a Date item (in "Date and Time" or "Duration" format) Modify the seconds or the number of seconds in a Date item (in "Date and Time" or "Duration" format)...
HErrorLock (Function)
Used to check whether a lock error occurred.
spMatchesDescription (Property)
The spMatchesDescription property determines if the parameters (key derivation function, hash algorithm, iteration count and output length) of the item of type "Password" in the data file match the parameters described programmatically or in the analysis.
<Source>.FilterIdentical (Function)
Defines and enables a filter used to find the exact value of a string item.
spDerivation (Property)
The spDerivation property is used to: Get the key derivation function used to hash an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically. Set the key derivation function used for hashing (only for "Password" items defined programmatically)....
spLength (Property)
The spLength property is used to: Get the hash output length. This property can be used for items of type "Password" defined in the data model editor or programmatically. Set the hash output length (only for "Password" items defined programmatically)....
spIterationCount (Property)
The spIterationCount property is used to: Get the iteration count of the hash algorithm used for an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically. Sets the iteration count of the hash algorithm used for an item of type "Password" (only for "Password" items described programmatically)....
spHash (Property)
The spHash property is used to: Get the algorithm used for salting an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically. Set the algorithm used for salting (only for "Password" items described programmatically)....
spAge (Property)
The spAge property gets the time elapsed since the password was last changed.
MultiLinestring2D (Variable type)
The MultiLinestring2D type can be used to store a collection of linestrings defined with 2D coordinates.
Address
The Address keyword can correspond to...
<Source>.StatCalculate (Function)
Performs various statistical calculations on the file keys.
<Source>.Read (Function)
Reads a record in a file according to a given record number.
Data model editor: the different types of items
The different types of items proposed in the data model editor are as follows:
1. Creating a WEBDEV project and its analysis
WEBDEV Tutorial - Creating a WEBDEV project and its analysis Lesson 1 - Creating a WEBDEV project and its analysis - 5 min
1. Creating a WINDEV project and its analysis
WINDEV Tutorial: Creating a WINDEV project and its analysis Lesson 1 - Creating a WINDEV project and its analysis - 5 min
Translating the interface into multiple languages
When the different languages supported by the application have been selected, the information displayed by the application must be translated into these different languages......
<Source>.Last (Function)
Sets the position on the last record of a data file according to a browse item.
<Source>.ErrorStatusModification (Function)
Returns the status of a record during a modification conflict.
<Source>.FilterStartsWith (Function)
Defines and enables a "Start with" filter on a file, view or query.
<Source>.FilterIncludedBetween (Function)
Defines and enables an "Included between" filter on a file, view or query.
Date (Property)
The Date property is used to: Retrieve the date from a DateTime variable. Modify the date in a DateTime variable. Retrieve the date from a Date item (in "Date and Time" format) . Modify the date in a Date item (in "Date and Time" format)...
HErrorStatusModification (Function)
Returns the status of a record during a modification conflict.
<Source>.ChangeKey (Function)
Changes the browse item.