ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

<Connection variable>.ManageServerUpdate (Function)
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates....
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.
Connection (Type of variable)
The Connection type is used to describe one or more connections to external databases (HFSQL Client/Server, Native Connector, etc....
<Source>.NbRec (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......
Application triggers
...A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a data file....
<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.
<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.
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.
<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......
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows......
4. HFSQL Classic
HFSQL Classic is the database format......
Examples for using the OLE DB provider for HFSQL
Native MySQL Connector for WINDEV and WEBDEV
WINDEV and WEBDEV propose a Native Connector for MySQL......
License agreement for the tools included with WINDEV, WEBDEV and WINDEV Mobile
License agreement for the tools included with WINDEV, WEBDEV and WINDEV Mobile...
<Source>.ListItem (Function)
Returns the list of items in a data file (query or view) recognized by the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
<Source>.ImportJSON (Function)
Imports a JSON file into a data file in HFSQL Classic format (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile).
HImportJSON (Function)
Imports a JSON file into a data file in HFSQL Classic format (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile).