ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

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......
HListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
HListScheduling (Function)
Lists the scheduled tasks defined on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
HBackup (Function)
Makes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
HDeleteScheduling (Function)
Deletes a scheduled task found on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
hScheduleMaterializedView (Type of variable)
The hScheduleMaterializedView type is used to programmatically manage a task for recalculating the data of a scheduled materialized view on an HFSQL server.
Optimizing the connection times to the HFSQL Client/Server databases
This help page explains how to optimize the connection times to the HFSQL Client/Server databases by limiting the network traffic......
<Source>.MergeView (Function)
Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism.
<Source>.ListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
<Connection variable>.ListScheduling (Function)
Lists the scheduled tasks defined on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
FilterCondition (Property)
The FilterCondition property allows you to know the selection condition set by HFilter on a data file, HFSQL view or query.
HMergeView (Function)
Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism.
Access (Property)
The Access property is used to manage the type of access of a connection (HFSQL Client/Server, OLE DB, etc.)....
Database (Property)
The Database property is used to manage databases associated with a connection (HFSQL Client/Server, OLE DB, etc.)....
Server (Property)
The Server property is used to manage the data source of a connection (HFSQL Client/Server, OLE DB, etc.)....
HRecordDate (Function)
Returns the date and time of the last write operation performed on a record in an HFSQL file (Classic or Client/Server)....
<Connection variable>.Backup (Function)
Makes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
<Connection variable>.DeleteScheduling (Function)
Deletes a scheduled task found on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
HIndexingInProgress (Function)
Indicates that a reindex operation is currently performed on an HFSQL data file and returns the percentage of reindexing already performed.
<Source>.IndexingInProgress (Function)
Indicates that a reindex operation is currently performed on an HFSQL data file and returns the percentage of reindexing already performed.
WDAdminHF: Saving the databases
The remote HFSQL administrator allows you to create backups of HFSQL Client/Server data files......
HManageServerUpdate (Function)
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates....
<Source>.ModifyStructure (Function)
Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization).
<Source>.NbRec (Function)
Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc.
HModifyStructure (Function)
Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization).