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.
Stemming (Property)
The Stemming property is used to enable stemming and to define the language used for stemming in a full-text index defined through programming.
SourceKey (Property)
The SourceKey property sets the characteristics of a link.
The different types of browse available in SQL
Two types of browse can be used to browse the result of a query run by SQLExec......
Synonym (Property)
The Synonym property is used to define synonyms in a programmatically defined full-text index.
SQLReqExists (Function)
Checks the existence of a query.
SQLFetch (Function)
Goes to the next row (i.e next record) of the query result.
Native Oracle Connector for WINDEV and WEBDEV
WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access......
WDLog: Restoring a data file from its log
WDLog is used to apply to a backup of a data file the different operations saved in the log of this file......
<Source>.Seek (Function)
Positions on the first record of the data file whose value for a specific item is greater than or equal to a sought value (generic search by default).
SQLChangeConnection (Function)
Modifies the current connection.
HInfoAnalysis (Function)
Returns information about an analysis (WDD file).
<Source>.ExecuteQueryAsynchronous (Function)
Executes a SELECT query asynchronously.
<Source>.JSONToRecord (Function)
Imports JSON data into the current record.
<Source>.RestorePosition (Function)
Restores the context of a previously saved file (HSavePosition): current record, filter, pointers.
<Source>.DeactivateAutoFilter (Function)
Disables an automatic filter on the linked files when browsing an XML file.
<Source>.RecordToXML (Function)
Retrieves the structure and the value of the current record and exports them into a character string in XML format.
SQLListSource (Function)
Lists the data sources declared on a local site.
<Source>.SavePosition (Function)
Stores the current file context: current record, filter, pointers.
<Source>.RecordToJSON (Function)
Retrieves the structure and value of the current record and exports them into a string in JASON format.
<Source>.Mode (Function)
Changes the mode and the method for locking data files.
HDBDescribeField (Function)
Describes through programming each item found in the structure of an xBase file described by HDBDescribeFile.
<Source>.State (Function)
Used to find out the state of a record.
ServiceWriteEventLog (Function)
Writes an event into the log of Windows events.
TimestampUTC (Property)
The TimestampUTC property is used to: Find out whether a timestamp item will use UTC time or local time. This item was defined in the data model editor or through programming. Define whether a timestamp item will use UTC time or local time (when describing the item through programming)....
Customizing the WEBDEV User Groupware
The groupware in automatic mode offers several possibilities......