|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Automatically updates:
the value of the items in a data file with the value of the controls in the page.
the value of the WLanguage variables with the value of the page controls.... |
|
|
|
|
|
|
|
| Returns the list of Custom-Folders (also called groups) defined in the analysis. |
|
|
|
|
|
|
|
| The TypeDescription property is used to:
Find out the type used by an Enumeration or Combination item. This item was defined in the data model editor or programmatically.
Define the type used by an Enumeration or Combination item (when describing the item through programming).... |
|
|
|
|
|
|
|
| Unlocks a file that was locked by the same program with HNoModif. |
|
|
|
|
|
|
|
| Forces the operating system of the computer where the data files are found to write data onto the disk. |
|
|
|
|
|
|
|
| Forbids all the modifications on a data file (for all the programs, including the one that requested the no-modification policy). |
|
|
|
|
|
|
|
| Initializes:
one or all variables of file items with their default values.
one or all items of a Record variable with their default values.... |
|
|
|
|
|
|
|
| Enables or disables the automatic security mechanism on one or more data files. |
|
|
|
|
|
|
|
| Automatically updates:
the value of the items in a data file with the value of the controls in the page. The data file items bound to the window controls are automatically updated with the values of these controls.
the value of the WLanguage variables with the value of the window controls. The WLanguage variables bound to the page controls are automatically updated with the values of these controls.
This operation is performed regardless of the state of the controls (grayed, inactive or invisible).... |
|
|
|
|
|
|
|
| Copies:
the content of the current record (loaded in memory) to the current data file record.
the content of the Record variable to the current data file record.... |
|
|
|
|
|
|
|
| Automatically updates the controls of a page with:
the values of the bound items in the current record (loaded in memory) of the data file described in the data model editor. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).... |
|
|
|
|
|
|
|
| Returns the modifications performed on one or more items of a given record. The result can be displayed in a list box or in a table to allow the user to view the modifications made to the specified file. |
|
|
|
|
|
|
|
| Automatically updates:
the value of the items in a data file with the value of the controls in the page.
the value of the WLanguage variables with the value of the page controls.... |
|
|
|
|
|
|
|
| Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| The KeySize property is used to set the characteristics of a text memo key item. |
|
|
|
|
|
|
|
| Opens an xBase index file. |
|
|
|
|
|
|
|
| In single-user mode, opens an xBase data file without locking it. |
|
|
|
|
|
|
|
| Returns or modifies the sequence of text items in the xBase files. |
|
|
|
|
|
|
|
| Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| The "Analysis" pane lists...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support an optional Native Oracle Connector (also called Native Oracle Access...... |
|
|
|
|
|
|
|
| The StopWord property is used to define stopwords in a full-text index defined through programming. |
|
|
|
|
|
|
|
| The Synonym property is used to define synonyms in a programmatically defined full-text index. |
|
|
|
|
|
|
|
| The Stemming property is used to enable stemming and to define the language used for stemming in a full-text index defined through programming. |
|
|
|
|
|
|
|
| The SourceKey property sets the characteristics of a link. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|