ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HFSQL Client/Server management functions
Several HFSQL functions are used to manage the HFSQL Client/Server data......
HTransaction (Function)
Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file.
<Source>.ExportCSV (Function)
Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file.
<Source>.ExportJSON (Function)
Exports the records found in a data file (HFSQL or OLE DB), view or query to a JSON 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.
HExportCSV (Function)
Exports the records found in a data file (HFSQL or OLE DB), a view or a query to a CSV file.
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.)....
<Connection variable>.Transaction (Function)
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction 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.
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......
4. HFSQL Classic
New Features brochure - Version 27: new features of WINDEV Mobile
New features in WINDEV Mobile 27 presented in the New Features brochure....
AppleSignIn (Function)
Used to implement authentication via "Sign In with Apple" on devices running on iOS 13 and higher.
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.
HListFullTextIndex (Function)
Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine.