ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

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....
<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....
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>.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.
Materialized view
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, ......
<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.
4. HFSQL Classic
HFSQL Classic is the database format......
Examples for using the OLE DB provider for HFSQL
<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).
RecordSize (Property)
The RecordSize property is used to get the size (in bytes) of a record in: a file described in the data model editor, a file described through programming, an HFSQL view, a query....
Managing the groups and users (HFSQL Client/Server)
To simplify the management of users and groups of users, the HFSQL Client/Server engine uses several variables allowing you to easily define the characteristics of groups and users......
Operating mode of HFSQL application
A HFSQL application can operate in network mode or in Client/Server mode......
3. Preparing the setup program
WINDEV Tutorial: Using an HFSQL Client/Server database Lesson 3 - Preparing the setup program - 5 min...
External language: Programming in Java
We are going to call the elements developed in WINDEV (project, windows, analysis, ......