|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The scheduled tasks are used to schedule automatic tasks... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| To ensure data security and confidentiality, some actions may be restricted to a group of users... |
|
|
|
|
|
|
|
| When creating the setup program of a WINDEV application using HFSQL Client/Server data files, the wizard allows you to... |
|
|
|
|
|
|
|
| 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 stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... |
|
|
|
|
|
|
|
| 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 backup of the HFSQL Client/Server databases can be performed ... |
|
|
|
|
|
|
|
| The ports used by the HFSQL Client/Server server... |
|
|
|
|
|
|
|
| Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis... |
|
|
|
|
|
|
|
| All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database... |
|
|
|
|
|
|
|
| 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, ...
|
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server data file. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Gets various statistics on the keys of an HFSQL Client/Server data file. 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... |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server data file (".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. |
|
|
|
|
|
|
|
| Required configuration and overview for installing HFSQL Cluster. |
|
|
|
|
|
|
|
| The following functions are used to manage an HFSQL cluster |
|
|
|
|
|
|
|
| Adds an optimization task of HFSQL Client/Server data files. |
|
|
|
|
|
|
|
| HFSQL Cluster is a database server intended to be deployed on several servers... |
|
|
|
|
|
|
|
| Adds an optimization task of HFSQL Client/Server data files. |
|
|
|
|
|
|
|
| The server that is hosting a HFSQL database engine can be very busy... |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server data file. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Gets various statistics on the keys of an HFSQL Client/Server data file. 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 data file (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server data file (".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. |
|
|
|
|
|
|
|
| The stored procedures and the triggers are debugged from the environment, with real execution on the server... |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Returns the time of the last update for the index statistics. |
|
|
|
|
|
|
|
| The Type property is used to get:
the type of element (data file or item) defined programmatically or in the data model editor, view or query.
the type of object.
the type of data held in a Variant.... |
|
|
|
|
|
|
|
| Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| In some cases, it may be useful to execute the same stored procedure multiple times by changing one or more parameters ...... |
|
|
|
|
|
|
|
| Crosses a record in a data file. |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Returns the time of the last update for the index statistics. |
|
|
|
|
|
|
|
| Returns the date of the last update for the index statistics. |
|
|
|
|
|
|
|
| Deletes a record from a data file (query or view). |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| The Millisecond property is used to:
Retrieve the number of milliseconds from a Time, DateTime or Duration variable.
Modify the number of milliseconds in a Time, DateTime or Duration variable.
Retrieve the milliseconds or the number of milliseconds from a Date item (in "Date and Time" or "Duration" format)
Modify the milliseconds or number of milliseconds in a Date item ("Date and Time" or "Duration" format)... |
|
|
|
|
|
|
|
| The Second property is used to:
Retrieve the number of seconds from a Time, DateTime or Duration variable.
Modify the number of seconds in a Time, DateTime or Duration variable.
Retrieve the seconds or the number of seconds from a Date item (in "Date and Time" or "Duration" format)
Modify the seconds or the number of seconds in a Date item (in "Date and Time" or "Duration" format)... |
|
|
|
|
|
|
|
| Used to check whether a lock error occurred. |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| Describes a file item through programming. |
|
|
|
|
|
|
|
| The spMatchesDescription property determines if the parameters (key derivation function, hash algorithm, iteration count and output length) of the item of type "Password" in the data file match the parameters described programmatically or in the analysis. |
|
|
|
|
|
|
|
| The spDerivation property is used to:
Get the key derivation function used to hash an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically.
Set the key derivation function used for hashing (only for "Password" items defined programmatically).... |
|
|
|
|
|
|
|
| The spLength property is used to:
Get the hash output length. This property can be used for items of type "Password" defined in the data model editor or programmatically.
Set the hash output length (only for "Password" items defined programmatically).... |
|
|
|
|
|
|
|
| The spIterationCount property is used to:
Get the iteration count of the hash algorithm used for an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically.
Sets the iteration count of the hash algorithm used for an item of type "Password" (only for "Password" items described programmatically).... |
|
|
|
|
|
|
|
| The spHash property is used to:
Get the algorithm used for salting an item of type "Password". This property can be used for items of type "Password" defined in the data model editor or programmatically.
Set the algorithm used for salting (only for "Password" items described programmatically).... |
|
|
|
|
|
|
|
| The spAge property gets the time elapsed since the password was last changed. |
|
|
|
|
|
|
|
| The MultiLinestring2D type can be used to store a collection of linestrings defined with 2D coordinates. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|