ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
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...
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
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 function is only available in subscription-based versions, starting with WINDEV Suite 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 function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
Unalterable data files
This feature is used to signal that a data file cannot be modified after writing...
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 function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
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 function is only available in subscription-based versions, starting with WINDEV Suite 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 function is only available in subscription-based versions, starting with WINDEV Suite 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 function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
HCheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
This function is only available in subscription-based versions, starting with WINDEV Suite 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...
<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 function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<Source>.CheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
HModifyFileProperty (Function)
Modifies the properties of an HFSQL file located on a server.
HInfoServer (Function)
Returns the specified information about the server.
HNoDatabaseAccess (Function)
Denies all new connections to a database or to all databases.
HEndNoDatabaseAccess (Function)
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
HStopServer (Function)
Stops an HFSQL server.
HModifyDatabaseProperty (Function)
Modifies the properties of a database located on an HFSQL server.
HInfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
HModifyServerProperty (Function)
Modifies the properties of an HFSQL server.
HDeleteDatabase (Function)
Deletes a database located on an HFSQL server.
HTransactionList (Function)
Returns the list of current or interrupted transactions on the server for the specified connection.
Feedback component
The Feedback component is a component provided with WINDEV......
ODBC on HFSQL via Visual .NET (in C#)
The ODBC driver on HFSQL Classic (single-user and multi-user) is used to access a HFSQL Classic database from an external database software that supports ODBC accesses......
HOperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
<Connection variable>.StartServerUpdate (Function)
Used to immediately start the automatic server update.
<Connection variable>.ActivateServerTrigger (Function)
Re-enables a server trigger that was disabled by HDeactivateServerTrigger.
<Connection variable>.AddLink (Function)
Adds an integrity rule between two files on the 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....
HCreateServerTrigger (Function)
Adds or modifies a server trigger on the HFSQL server.
<Connection variable>.DisconnectClient (Function)
Displays a message on the Client computer(s) and disconnects the application.
<Connection variable>.DuplicateDatabase (Function)
Duplicates the database associated with a connection on an HFSQL server.
<Connection variable>.InfoView (Function)
Returns information about a materialized view.
<Connection variable>.ConnectionQuality (Function)
Returns the quality level of connection: the higher the level is, the faster the connection will be.
<Connection variable>.RetrieveLog (Function)
Creates a text file containing the server logs between two given dates.