ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

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.
HMergeView (Function)
Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism.
Analysis: Import files into the analysis (external database, HFSQL files, etc.)
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc....
Multi-database queries
A query (typed in SQL code) can operate on different databases......
HModifyStructure (Function)
Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization).
<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.
FilterWithBounds (Property)
The FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL data file, view or query.
DescribedName (Property)
The DescribedName property is used to handle the logical name of HFSQL data files (ignoring possible changes made by HAlias).
HNbRec (Function)
Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc.
Native Oracle Connector: Programming with SQL functions
The SQL functions can be used to handle the ORACLE database, regardless of whether WDORAINS is used or not to configure the accessed database......
<Source>.MigrateLinkedCompositeKey (Function)
Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format.
<Source>.ToFile (Function)
Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected.
FileToMemoryTable (Function)
Populates a Table control programmatically with the records from a data file, HFSQL view or query (query created in the query editor or with HExecuteSQLQuery).
HMigrateLinkedCompositeKey (Function)
Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format.
HToFile (Function)
Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected.
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows......
<Source>.ViewToFile (Function)
Saves the modifications performed in an HFSQL view (by HModify, HDelete or HCross) in the corresponding data file. This function uses the former view mechanism.
HViewToFile (Function)
Saves the modifications performed in an HFSQL view (by HModify, HDelete or HCross) in the corresponding data file. This function uses the former view mechanism.
UUID (Type of variable)
The UUID type is used to easily manage: UUIDs or GUIDs, automatic UUID HFSQL identifiers, identifiers for COM/Automation objects and interfaces, ......
SQL : ORDER BY clause: Organizing the result of a query
The ORDER BY clause is used to sort the records selected by an SQL query......
<HFSQL connection>.TransactionSavepoint (Function)
Declares a transaction savepoint.
4. HFSQL Classic
HFSQL Classic is the database format......
Native MySQL Connector for WINDEV and WEBDEV
WINDEV and WEBDEV propose a Native Connector for MySQL......