ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

The user version of query editor (Reports & Queries)
A query is used to interrogate a database in order to view, insert, modify or delete data......
HFSQL and Docker
Docker is a software platform that allows you to run applications in software containers on Linux (Docker runs like a daemon)......
SQLLast (Function)
Sets the position on the last row of the query result.
User Groupware: Configuring the application
Once the User Groupware is configured, the configuration of users and accesses is performed at runtime, by connecting with a "supervisor" account......
HPass (Function)
Defines the password used to create or open a data file.
The OLE control
The OLE control is used to handle an OLE object......
HCancelBackup (Function)
Cancels a current backup.
HDeleteScheduledBackup (Function)
Deletes a scheduled backup from an HFSQL Client/Server server....
Application triggers
...A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a data file....
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......
8. 10 tips for better interfaces...
<Source>.ChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
User Groupware: Configuring the site
Once the User Groupware is configured, the configuration of users and accesses is performed at runtime, by connecting with a "supervisor" account......
hbWrite (Function)
Writes cells (values of items) to one or more rows (records) in an HBase table.
<Connection variable>.RegenerateFile (Function)
Regenerates a data file from its log.
<Connection variable>.AddLink (Function)
Adds an integrity rule between two files on the server.
<Connection variable>.AddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files....
<Connection variable>.AddScheduling (Function)
Creates a scheduled task on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
<Connection variable>.ActivateServerTrigger (Function)
Re-enables a server trigger that was disabled by HDeactivateServerTrigger.
<Connection variable>.StopServer (Function)
Stops an HFSQL server.
<Connection variable>.LoadParameter (Function)
Reads a parameter that was saved from a stored procedure by HSaveParameter.
<Connection variable>.CopyFile (Function)
Copies an HFSQL data file (.fic, .ndx and .mmo files if they exist): from the HFSQL server to the server (to perform a backup for example). from the HFSQL server to the client (to perform a local backup for example). from the client to the HFSQL server (to update the data files for example). from an HFSQL server to antoher HFSQL server....
<Connection variable>.StartServerUpdate (Function)
Used to immediately start the automatic server update.
<Connection variable>.DisconnectClient (Function)
Displays a message on the Client computer(s) and disconnects the application.
<Connection variable>.DeactivateServerTrigger (Function)
Disables a HFSQL Client/Server server trigger on a server....