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.
<Source>.LockFile (Function)
Locks a data file and restricts the access to this data file for all other sites or applications.
<Source>.DeleteTrigger (Function)
Deletes a trigger.
<Source>.StatNbDuplicates (Function)
Returns the number of duplicates for a given key item.
<Source>.StatNbRecRange (Function)
Returns an estimate regarding the number of entries for a given key item in a given interval of values.
HDescribeItem (Function)
Describes a file item through programming.
<Source>.StatNbRec (Function)
Returns the number of entries for a given key item.
<Source>.LogInfo (Function)
Adds comments to the log when saving the operation.
<Source>.LogRecreate (Function)
Used to re-create an empty log.
<Source>.LogRestart (Function)
Restarts the logging process on a file.
<Source>.LogStop (Function)
Stops the log process of a file.
Composite keys
A composite key is a key item containing several other items......
Linestring2DAddPoint (Function)
Adds a new point to a 2D linestring.
HStatNbDuplicates (Function)
Returns the number of duplicates for a given key item.
<Source>.GetCurrentPosition (Function)
Returns the approximate position of current record in the data file.
HLogInfo (Function)
Adds comments to the log when saving the operation.
HLogRecreate (Function)
Used to re-create an empty log.
HLogRestart (Function)
Restarts the logging process on a file.
HLogStop (Function)
Stops the log process of a file.
<Source>.SetPosition (Function)
Sets the position on a record, based on the approximate position of one of its items.
HStatNbRec (Function)
Returns the number of entries for a given key item.
HDeleteTrigger (Function)
Deletes a trigger.
HStatNbRecRange (Function)
Returns an estimate regarding the number of entries for a given key item in a given interval of values.
HCross (Function)
Crosses a record in a data file.
GglAddressToCoordinates (Function)
Retrieves the coordinates (latitude/longitude) of an address....
PC SOFT Free Technical Support
Thank you for buying one of our products......