|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The SQL functions can be used to handle the ORACLE database, regardless of whether WDORAINS is used or not to configure the accessed database...... |
|
|
|
|
|
|
|
| ...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.... |
|
|
|
|
|
|
|
| Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected. |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
|
| Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| The UUID type is used to easily manage:
UUIDs or GUIDs,
automatic UUID HFSQL identifiers,
identifiers for COM/Automation objects and interfaces,
...... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query...... |
|
|
|
|
|
|
|
| The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...... |
|
|
|
|
|
|
|
| HFSQL Classic is the database format...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose a Native Connector for MySQL...... |
|
|
|
|
|
|
|
| License agreement for the tools included with WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| We are going to call the elements developed in WINDEV (project, windows, analysis, ...... |
|
|
|
|
|
|
|
| Imports an XML file into an HFSQL Classic or Client/Server data file (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile).... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|