ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

<Source>.ImportJSON (Function)
Imports a JSON file into an HFSQL Classic table. This table must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile).
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.
<Source>.ListItem (Function)
Returns the list of items in a table (query or view) recognized by the HFSQL engine. The tables defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
HImportJSON (Function)
Imports a JSON file into an HFSQL Classic table. This table must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile).
UUID (Variable type)
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.
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 table....
HListSchedulingHistory (Function)
Lists the executions of a scheduled job on an HFSQL server. This job can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh.
<Connection variable>.ListSchedulingHistory (Function)
Lists the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh.
HDeleteSchedulingHistory (Function)
Deletes the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh.
<Connection variable>.DeleteSchedulingHistory (Function)
Deletes the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh.
4. HFSQL Classic
HFSQL Classic is the database format......
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows......
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......
Native MySQL Connector for WINDEV and WEBDEV
WINDEV and WEBDEV propose a Native Connector for MySQL......
Examples for using the OLE DB provider for HFSQL
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...
<Source>.Watch (Function)
Trigger monitoring of write actions (add, modify or delete) performed on a table present on an HFSQL server. In case of modification, a specific procedure can be triggered.