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...
<Connection variable>.ServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
HFSQL and Docker
Docker is a software platform that allows you to run applications in software containers on Linux (Docker runs like a daemon)...
<Connection variable>.StartServerUpdate (Function)
Used to immediately start the automatic server update.
HServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
HManageServerUpdate (Function)
Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates.
<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.
<Connection variable>.OperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
HOperationInProgress (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.
Installing an HFSQL Client/Server server with an application
When creating the setup program of a WINDEV application using HFSQL Client/Server tables, the wizard allows you to...
HListServer (Function)
Lists the HFSQL servers installed on a computer.
HStartServerUpdate (Function)
Used to immediately start the automatic server update.
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)....
GeometryCoveredBy (Function)
Determines if every point of geometry A lies inside or on the boundary of geometry B.
<Source>.StatCalculate (Function)
Performs various statistical calculations on the file keys.
<Source>.Last (Function)
Sets the position on the last record of a table according to a browse item.
MultiLinestring2D (Variable type)
The MultiLinestring2D type can be used to store a collection of linestrings defined with 2D coordinates.
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 table match the parameters described programmatically or in the database schema.
<PolygonGeo variable>.Intersection (Function)
Returns a geometry representing the intersection between a geographic polygon and another geometry.
<Polygon2D variable>.Intersect (Function)
Checks whether the intersection of a 2D polygon and another geometry does not result in an empty set.
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 defined programmatically)....
MultiPolygonGeo (Variable type)
The MultiPolygonGeo type can be used to store a collection of non-overlapping polygons defined with geographic coordinates.
spAge (Property)
The spAge property gets the time elapsed since the password was last changed.
PolygonGeo (Variable type)
The PolygonGeo type is used to define all the advanced characteristics of a geographic polygon.
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)...
<Source>.Read (Function)
Reads a record in a file according to a given record number.
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
Data model editor: the different types of items
The different types of items proposed in the data model editor are as follows:
<Source>.ErrorStatusModification (Function)
Returns the status of a record during a modification conflict.
HErrorStatusModification (Function)
Returns the status of a record during a modification conflict.
<Source>.FilterIncludedBetween (Function)
Defines and enables an "Included between" filter on a file, view or query.
<Source>.FilterStartsWith (Function)
Defines and enables a "Start with" filter on a file, view or query.
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