ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

Docker image of the HFSQL server
A Docker container with the HFSQL server is available on Docker Hub...
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, ...
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.
HOperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
<Connection variable>.ServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
<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.
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.
PageFromSource (Function)
Automatically updates the controls of a page with: the values of the bound items in the current record (loaded in memory) of the HFSL table described in the data model editor. the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible)....
<Source>.ToPage (Function)
Automatically updates the controls of a page with: the values of the bound items in the current record (loaded in memory) of the HFSL table described in the data model editor. the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible)....
CtCacheSize (Property)
The CtCacheSize property is used to determine and change the maximum number of records that can be stored in the cache of the Native MySQL Connector.
Browsing the HFSQL data files
The "Key" items are used to organize the records in a data file in order to optimize the browse or the search......
<HFSQL connection>.TransactionRollbackToSavepoint (Function)
Rolls the transaction back to the savepoint.
7. HFSQL: Physical files
Opens a system window to select a resource from: from the device file system, from the Cloud (Google Drive, Microsoft OneDrive, etc.) or from one of the content managers installed on the device....
Using Unicode in HFSQL tables
The database schema proposes two types of Unicode items......
7. HFSQL: Physical files
Checks the validity of an IdNr (personal identification number in Germany)....
Appendix 3: Configuration file
For compatibility with previous versions of the SQL Server Native Connector (also known as SQL Server Native Access), it is still possible to configure the connection in the WDSQSINS software (delivered with the SQL Server Native Connector)......
WDSQL: Creating an SQL query
Once the connection to the database is established, WDSQL allows you to create different types of SQL queries......
Native Sybase Connector: Output value of a stored procedure run on the server
The Native Sybase Connector (also called Native Sybase Access) is used to: specify the input values during the call to a stored procedure. retrieve the output values after a call to a stored procedure....
gglCalendar (Type of variable)
The gglCalendar type is used to describe and modify a calendar used by the Google Calendar service...
gglContact (Type of variable)
The gglContact type is used to describe and modify a contact used by the Google Contacts service...
SaaSDisconnect (Function)
Disconnect the user of a SaaS site beside the SaaS web service that manages the site.
Deploying a site (from the development computer)
Regardless of the type of site created by WEBDEV (static site or dynamic site), WEBDEV Development version allows your to automatically install the site on the server......
upnpService (Type of variable)
The upnpService type is used to define the advanced characteristics of a service provided by the UPnP device.
BTLEGetAService (Function)
Retrieves the service of a Bluetooth Low Energy device corresponding to the specified identifier (UUID).
BTLEGetACharacteristic (Function)
Retrieves the characteristic of a Bluetooth Low Energy service corresponding to the specified identifier (UUID).
grSeriesPointType (Function)
Modifies the type of point for a series found in a Line, Area, Scatter and Radar chart.
grSeriesLineType (Function)
Modifies the type of line for a series found in a Line, Area, Scatter and Radar chart.
<btleService variable>.GetACharacteristic (Function)
Retrieves the characteristic of a Bluetooth Low Energy service corresponding to the specified identifier (UUID).
<btleDevice variable>.GetAService (Function)
Retrieves the service of a Bluetooth Low Energy device corresponding to the specified identifier (UUID).