ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HRecordDate (Function)
Returns the date and time of the last write operation performed on a record in an HFSQL file (Classic or Client/Server)....
Database (Property)
The Database property is used to manage databases associated with a connection (HFSQL Client/Server, OLE DB, etc.)....
ExecutionCompleted (Property)
The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed....
Server (Property)
The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.)....
Access (Property)
The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.)....
WDInst: Installing an HFSQL Client/Server application
When creating the setup program of a WINDEV application that uses HFSQL Client/Server data files, WDInst allows you to......
Check: Connectivity to HFSQL Client/Server
The monitoring robot will try to connect to a HFSQL Client/Server server......
Connection (Type of variable)
The Connection type is used to describe one or more connections to external databases (HFSQL Client/Server, Native Connector, etc....
HFSQL Control Center: Overview
The HFSQL Control Center is used to manage the different HFSQL databases (Network, Mobile, Client/Server) found in the company......
ODBC driver for HFSQL Classic and for HFSQL Client/Server (Windows)
The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic database from an external database software that supports the accesses by ODBC......
Managing HFSQL Client/Server databases
The HFSQL Control Center allows you to fully manage HFSQL Client/Server databases......
WDAdminHF: Managing a database
The remote HFSQL administrator proposes a full management of the HFSQL Client/Server databases......
Operating mode of HFSQL application
A HFSQL application can operate in network mode or in Client/Server mode......
3. Preparing the setup program
WINDEV Tutorial: Using an HFSQL Client/Server database Lesson 3 - Preparing the setup program - 5 min...
Managing the groups and users (HFSQL Client/Server)
To simplify the management of users and groups of users, the HFSQL Client/Server engine uses several variables allowing you to easily define the characteristics of groups and users......
HImportXML (Function)
Imports an XML file into an HFSQL Classic or Client/Server data file (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile)....
<Source>.ImportXML (Function)
Imports an XML file into an HFSQL Classic or Client/Server data file (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile)....
Remote HFSQL administrator: Overview
The remote HFSQL administrator is a WEBDEV site installed with the WEBDEV application server and used to remotely manage the HFSQL Client/Server databases installed on the Web server......
HImportText (Function)
Imports a Text file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
HImportXLS (Function)
Imports an XLS file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
<Source>.ImportXLS (Function)
Imports an XLS file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
Procedure
The Procedure property can be used: on the hScheduledTask type, used to describe the scheduled tasks on an HFSQL Client/Server database. on the rssStream type, used to describe an RSS feed....
<Source>.ImportText (Function)
Imports a Text file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
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 (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
HFSQL Client/Server functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
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...
Restoring an HFSQL Client/Server database
A backup of an HFSQL Client/Server database can be restored at any time...
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: Backing up databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis...
User Groupware and Client/Server data files
An application using User Groupware can be used with a HyperFileSQL database in Client/Server mode...
<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>.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.
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.
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.
<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.
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.
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.
Unalterable data files
This feature is used to signal that a data file cannot be modified after writing...
HSendMessageToClient (Function)
Displays a message on the client computers.
<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.
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, ...
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
HFSQL Cluster functions
The following functions are used to manage an HFSQL cluster
HCheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
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).
1
2
3
4
5
6
25
>