ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

<Connection variable>.Transaction (Function)
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
<Source>.ExportXLS (Function)
Exports records from a data file (HFSQL or OLE DB), view or query to an Excel file (XLSX).
<Source>.Track (Function)
Starts tracking write actions (addition, modification or deletion) performed on a file found in an HFSQL server.
<Source>.SortView (Function)
Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism.
<Connection variable>.AddScheduling (Function)
Creates a scheduled task on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
<Connection variable>.ModifyScheduling (Function)
Modifies a scheduled task on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
HFSQL properties
List of HFSQL properties...
HTransactionStart (Function)
Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file.
HSortView (Function)
Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism.
HFSQL Client/Server management functions
Several HFSQL functions are used to manage the HFSQL Client/Server data......
Provider (Property)
The Provider property is used to manage the type of a connection (HFSQL Client/Server, OLE DB, etc.)....
User (Property)
The User property is used to manage the user of a connection (HFSQL Client/Server, OLE DB, etc.)....
<Source>.ExportJSON (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON file.
<Connection variable>.TransactionStart (Function)
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
<Source>.ExportXML (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
HExportXML (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file.
4. HFSQL Classic
HListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.
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.
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......
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.
HDeleteScheduling (Function)
Deletes a scheduled task found on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
HListScheduling (Function)
Lists the scheduled tasks defined on an HFSQL server: stored procedure, backup, optimization, refresh of materialized view....
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.