ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Control Centers / HFSQL Control Center
  • Overview
  • Starting the HFSQL Control Center
  • Starting the HFSQL Control Center
  • Use conditions
  • Features of HFSQL Control Center
  • HFSQL Control Center options
  • General" options
  • Data visualization" options
  • SQL query" options
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
The HFSQL Control Center is used to manage the different HFSQL databases (Network, Mobile, Client/Server) as well as the external databases.
Starting the HFSQL Control Center

Starting the HFSQL Control Center

To start the HFSQL Control Center:
  • from WINDEV, WEBDEV or WINDEV Mobile: on the "Tools" tab, in the "Database" group, click "HFSQL".
  • run "CCxx0HF.EXE" directly.
  • from a data file (double-click a ".FIC" file),

Use conditions

The HFSQL Control Center can be redistributed.
Features of HFSQL Control Center
The HFSQL Control Center is used to manage:
Options of CCHF
  • The HFSQL Client/Server databases. You can handle and get the details of:
    • the server: Stop, restart, server configuration, definition of users, scheduled tasks, backups.
    • the database: Description, search, backup, maintenance of data files, transactions, etc.
    • each database file: Description, content, search, logs, transactions, etc.
  • HFSQL Classic files. You have the ability to get information and to handle each database file: Description, content, search, logs, transactions, etc.
  • An analysis. You have the ability to get information and to handle all the data files of the analysis. These data files can be:
    • HFSQL Client/Server,
    • HFSQL Classic,
    • External databases
  • The external databases. You have the ability to get information and to handle data files not in HFSQL format:
    • Oracle,
    • SQL Server
    • MySQL
    • etc.
  • An HFSQL cluster. You have the ability to get information and to handle HFSQL Cluster data files.
HFSQL Control Center options
The HFSQL Control Center proposes several general options regarding the available features. To display these options:
  1. Expand the HFSQL Control Center menu ().
  2. Select "Options".
The options configuration window appears. This window groups options according to 3 themes:
  • General options.
  • Viewing data.
  • SQL queries.

General" options

The available options are:
  • Display the "x" icon to view the specified passwords: Used to display an eye beside the "Password" controls. All you have to do is click this icon to see the password typed.
  • Show the system database of HFSQL servers (requires the rights to connect to the database): Used to display the system database of HFSQL servers.
  • Remember displayed tabs (HFSQL Client/Server connections only): This option saves the open views (tabs displaying information about the server, database, data file , query, etc.) if the Control Center is closed or disconnected. Tabs are automatically restored next time the Control Center is opened. This option is selected by default.
    The "reset" option resets the saved views.
  • Item display order: Allows you to specify the order of items used in the data file description ("Description" tab of the data file). You can choose between logical order (default) or alphabetical order.
  • New in version 2024
    Maximum number of open tabs: Allows you to limit the maximum number of shutters open simultaneously. This saves memory resources.
  • New in version 2024
    ""Don't show again" dialog boxes": This button lists the questions and answers stored in the "Do not show again" dialog boxes displayed by the HFSQL Control Center.. It is thus possible to deactivate or reactivate the display of these dialog boxes.

Data visualization" options

New in version 2024
The available options are:
  • Show Text Memo items: Displays text memo headings in of the data file content.
  • Binary memo headings:
    • Show content: Displays the contents of the binary memo directly. Warning: this option may slow down Display of the data file content .
    • Show content only if connection quality is sufficient, otherwise show size: Image memos will only be displayed if the connection quality is sufficient.. Otherwise, only the memo size will be displayed.. This option is used to optimize the accesses and the data display. Please note that this option may slow down the display of of the data file content.
    • Show size only (option by Default ): Displays the binary memo field, specifying only the memo size.
    • Don't display: Binary memo items will not be displayed in of the data file content. .
  • Show composite keys: Displays compound keys and their contents.
  • Show text on multiple lines: This option displays all text fields on several rows, if required.. In this case, you can define:
    • if only text memos are concerned.
    • maximum number of Rows.
  • Show record numbers: Displays the Record number in the first column of the table listing Record of the data file.
  • Show date the records were last modified (tooltip): Displays Record modification date in a Tooltip.
It is also possible to specify whether modification of records can be carried out directly from the HFSQL Control Center via the option "Allow modification of records in table ". All you have to do is specify how you want to Interoperability the record files by double-clicking on them (view or edit mode)..

SQL query" options

The available options are:
  • Enable integrity management when running SQL queries: Used to take into account the management of integrity when running SQL queries from the HFSQL Control Center.
  • Enable management of duplicates when running SQL queries: Used to take into account the management of duplicates when running SQL queries from the HFSQL Control Center.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 02/07/2024

Send a report | Local help