|
|
|
|
|
|
|
|
|
|
|
|
|
|
| When creating the setup program of a WINDEV application using HFSQL Client/Server tables, the wizard allows you to... |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... |
|
|
|
|
|
|
|
| This help page presents the main recommendations for optimizing the security and performance of an HFSQL Client/Server database according to the constraints and desired features... |
|
|
|
|
|
|
|
| The backup of the HFSQL Client/Server databases can be performed ... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| A backup of an HFSQL Client/Server database can be restored at any time... |
|
|
|
|
|
|
|
| The ports used by the HFSQL Client/Server server... |
|
|
|
|
|
|
|
| To ensure data security and confidentiality, some actions may be restricted to a group of users... |
|
|
|
|
|
|
|
| Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis... |
|
|
|
|
|
|
|
| The scheduled tasks are used to schedule automatic tasks... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server table (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| HFSQL Cluster is a database server intended to be deployed on several servers... |
|
|
|
|
|
|
|
| Gets various statistics on the keys of an HFSQL Client/Server table. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server table (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server table. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| A server may encounter problems without any user (or developer) noticing anything. For example: - a scheduled task may fail,
- an automatic backup may fail,
- a node may become inactive in an HFSQL cluster, ...
|
|
|
|
|
|
|
|
| The following functions are used to manage an HFSQL cluster |
|
|
|
|
|
|
|
| A structure is a custom type of data... |
|
|
|
|
|
|
|
| Required configuration and overview for installing HFSQL Cluster. |
|
|
|
|
|
|
|
| The server that is hosting a HFSQL database engine can be very busy... |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| The stored procedures and the triggers are debugged from the environment, with real execution on the server... |
|
|
|
|
|
|
|
| All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database... |
|
|
|
|
|
|
|
| The remote HFSQL administrator is a WEBDEV site installed with the WEBDEV application server and used to remotely manage the HFSQL Client/Server databases installed on the Web server... |
|
|
|
|
|
|
|
| Adds an optimization task of HFSQL Client/Server tables. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server table. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Kerberos is an authentication mode based on the use of tickets and secret keys... |
|
|
|
|
|
|
|
| Gets various statistics on the keys of an HFSQL Client/Server table. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Adds an optimization task of HFSQL Client/Server tables. |
|
|
|
|
|
|
|
| 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,
...... |
|
|
|
|
|
|
|
| HFSQL Classic is the database format...... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose a Native Connector for MySQL...... |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| We are going to call the elements developed in WINDEV (project, windows, analysis, ...... |
|
|
|
|
|
|
|
| License agreement for the tools included with WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| We are going to call the elements developed in WINDEV (project, windows, analysis, ...... |
|
|
|
|
|
|
|
| The NbMemoItem property is used to get the total number of memo items in a record of:
a file described in the data model editor,
a file described through programming,
an HFSQL view,
a query.... |
|
|
|
|
|
|
|
| Returns the list of items:
found in a table (a query or a view) known to the HFSQL engine. The tables defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
found in a Record variable.... |
|
|
|
|
|
|
|
| To use a Sybase database with Native Connector, the structure of Sybase tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| To use an Informix database with the Native Connector, import the structure of Informix tables into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| Some WLanguage functions are not available in PHP...... |
|
|
|
|
|
|
|
| The WDD55Password property is used to specify the password of the 5.5 analysis that contains a Hyper File 5.5 data file used in an HFSQL Classic analysis. |
|
|
|
|
|
|
|
| Allows you to:
Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the table is no longer recognized by the HFSQL engine.
Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).... |
|
|
|
|
|
|
|
| Allows you to:
Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the table is no longer recognized by the HFSQL engine.
Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).... |
|
|
|
|
|
|
|
| The Charset property is used to:
Get the character set used by a Font variable.
Change the character set used by a Font variable.
Get the character set used by an HFSQL table.... |
|
|
|
|
|
|
|
| To use an SQLite database with Native Connector (also called Native Access), the structure of SQLite tables must be imported into the data model editor.... |
|
|
|
|
|
|
|
| The text files created by WDMSG use a specific format...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|