|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| The UUID type is used to easily manage:
UUIDs or GUIDs,
automatic UUID HFSQL identifiers,
identifiers for COM/Automation objects and interfaces,
...... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| HFSQL Classic is the database format...... |
|
|
|
|
|
|
|
| The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose a Native Connector for MySQL...... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| 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...... |
|
|
|
|
|
|
|
| A HFSQL application can operate in network mode or in Client/Server mode...... |
|
|
|
|
|
|
|
| WINDEV Tutorial: Using an HFSQL Client/Server database Lesson 3 - Preparing the setup program - 5 min... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|