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.
gpwOpenConnection (Function)
Opens a connection to a specific Client/Server database to manage the files of user groupware in Client/Server mode....
CursorOptions (Property)
The CursorOptions property is used to manage the type of cursor used for a connection (Native Connectors, OLE DB, etc.).
Automatic update (Network applications)
This step of the wizard allows managing the automatic updates of the applications from the reference server....
HCS.FrameSize (Variable)
The HCS.FrameSize variable is used to resize the outgoing data frame.
Synchronizing the analysis with external databases
The analysis must be synchronized with an external database if it uses......
HFirst (Function)
Sets the position on the first record of a data file according to the specified browse item.
HLast (Function)
Sets the position on the last record of a data file according to a browse item.
Android application: Using and sharing SQLite data
For the Android applications, the available databases are HFSQL (Classic and Client/Server) and SQLite....
HFSQL constants
List of constants used by the HFSQL functions....
SQLTable (Function)
Transfers the result of a query to a Table control populated programmatically (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows).
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows......
HOptimize (Function)
Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter.
HPrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
User Groupware (WINDEV and WEBDEV): Options and settings
An application is often intended to be used by several users connected via a network......
HDescribeLink (Function)
Describes a link between two data files through programming.
HAccelerateSpeed (Function)
Reorganizes the internal structure of the indexes to optimize the speed for accessing the data.
1. Application overview
WINDEV Mobile tutorial: Developing an Android and iOS application Lesson 1 - Application overview - 10 min
SQLDisconnect (Function)
Closes the current connection and frees the memory used by the connection.
HUnlockFile (Function)
Unlocks the records of a data file: locked by HLockFile. individually locked by a locking read function....
Setup by HTTP (Network setup via IP)
The network setup via HTTP consists in installing and updating a WINDEV application via an HTTP server (Live update)......
HStatCalculate (Function)
Performs various statistical calculations on the file keys.
HRetrieveItem (Function)
Returns the content of an item found in the current record (in the data file, view, query, ...).
Constants for managing errors and exceptions
List of constants used by the functions for managing errors and exceptions....
Setting up a WEBDEV cluster
With the WEBDEV Application Server in version 27, you can create server clusters with ease......
HRead (Function)
Reads a record in a file according to a given record number.