ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
Restoring an HFSQL Client/Server database
A backup of an HFSQL Client/Server database can be restored at any time...
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...
HFSQL Client/Server: Overview
You have the ability to create applications that access the HFSQL Client/Server databases...
User Groupware and Client/Server data files
An application using User Groupware can be used with a HyperFileSQL database in Client/Server mode...
HFSQL Client/Server: Backing up databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis...
Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
HFSQL Client/Server database: Recommendations
This help page presents the main recommendations for optimizing the security and performance of an HFSQL Client/Server database according to the constraints and desired features...
User Groupware and Client/Server data files
An application that uses the User Groupware can be used with an HFSQL database in Client/Server mode...
How to backup HFSQL Client/Server databases?
The backup of the HFSQL Client/Server databases can be performed...
HFSQL Client/Server functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
HCheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
<HFSQL connection>.StatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
<HFSQL connection>.CheckIndexAsynchronous (Function)
Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file).
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
Unalterable data files
This feature is used to signal that a data file cannot be modified after writing...
HCheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
HCheckIndexAsynchronous (Function)
Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file).
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
HSendMessageToClient (Function)
Displays a message on the client computers.
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 connection>.CheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
HFSQL Cluster functions
The following functions are used to manage an HFSQL cluster
HStatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
HReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server data file (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
WDLog: Backup of HFSQL data files
WDLog allows you to save all the HFSQL data files used by a WINDEV or WEBDEV application...
<Source>.CheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
<HFSQL connection>.ReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server data file (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
ODBC driver for HFSQL Classic and HFSQL Client/Server - License agreement
Control Centers: Working in offline mode
When working on a laptop computer or on an offline computer, you may want to continue working with the data found in the Control Centers (schedule management, quality management, etc....
OLE DB driver for HFSQL Classic and HFSQL Client/Server - License agreement
Working with the Source Code Manager
The principle for working with the Source Code Manager is as follows......
Handling data files in PHP
WEBDEV allows you to create a PHP site that handles data files......
HFSQL Control Center: Open an analysis
The HFSQL Control Center allows you to fully manage an analysis......
WDMap: Overview
WDMap is a tool used to view and handle a data file while developing an application......
The source code manager
WINDEV, WEBDEV and WINDEV Mobile propose a sophisticated Source Code Manager......
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....
Errors while managing data files
When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError......
Custom-Folders in the analysis
Several file descriptions can be grouped into a "Custom-Folder"......
HClient structure
The HClient structure is used to......
Natif Informix Connector for WINDEV and WEBDEV
WINDEV and WEBDEV propose an optional Native Connector to Informix (also called Native Access......
<Connection variable>.AddGroup (Function)
Adds a group of users.
<Connection variable>.AddUser (Function)
Adds a user to a database.
<Connection variable>.TransactionIsolation (Function)
Configures the isolation mode of transactions for a connection to an HFSQL server.
<Connection variable>.ModifyTask (Function)
Modifies a scheduled task on the HFSQL server defined by the connection.
HAddUser (Function)
Adds a user to a database.
HAddGroup (Function)
Adds a group of users.
HFSQL Control Center: HFSQL Cluster management
The HFSQL Control Center includes all the tools needed to manage HFSQL clusters......
HTransactionIsolation (Function)
Configures the isolation mode of transactions for a connection to an HFSQL server.
<Connection variable>.ExecuteProcedure (Function)
Runs a stored procedure.
<Connection variable>.UpdateQuery (Function)
Creates or updates a query on an HFSQL server.
HResetGroup (Function)
Initializes the structure for group management (HGroup) with the default values.
HClearWorkingDir (Function)
Clears and destroys the temporary directory previously created when HServerWorkingDir was executed.
1
5
6
7
8
9
25
>