Starting 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 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.

1. Expand the HFSQL Control Center menu ().
2. Select "Options".

• 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.
• Display image memos only if the quality of the connection to the HFSQL server is sufficient: If this option is not checked, the image memos will always be displayed. If this option is checked, the images memos will be displayed only if the quality of the connection is sufficient. This option is used to optimize the accesses and the data display.
• Display 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.
• 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.