ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Control Centers / HFSQL Control Center
  • Overview
  • Characteristics of the analysis
  • "HFSQL Classic" tab
  • "HFSQL C/S" tab
  • "External database" tab
  • "Links" tab
  • Ribbon 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
HFSQL Control Center: Open an analysis
Overview
The HFSQL Control Center allows you to fully manage an analysis. It gives access to all the databases found in the analysis: HFSQL Classic, HFSQL Client/Server and external databases.
The characteristics of an analysis can be displayed:
  • by starting the HFSQL Control Center from a project:
    1. Open the WINDEV, WINDEV Mobile or WEBDEV project.
    2. On the "Tools" tab, in the "Database" group, click "HFSQL".
    3. The home window of HFSQL Control Center is displayed. The "Open an analysis" option is selected and the path of the current analysis appears in the input field.
      Opening an analysis (CC HFSQL)
    4. Validate. The analysis is opened in the HFSQL Control Center.
  • from the HFSQL Control Center:
    1. Start the HFSQL Control Center.
    2. In the home window, click "Open an analysis".
    3. Specify the analysis path (WDD file) and the analysis password if necessary.
    4. Validate. The analysis is opened in the HFSQL Control Center.
Characteristics of the analysis

"HFSQL Classic" tab

This tab shows information about the HFSQL Classic data files in the analysis. The following information is displayed:
  • Logical name of data file,
  • Full path (if it exists),
  • Size of the data file,
  • Number of active records,
  • Number of deleted records,
  • Total number of records.

"HFSQL C/S" tab

This tab shows information about the HFSQL Client/Server data files in the analysis. The following information is displayed:
  • Logical name of data file,
  • Server,
  • Associated database,
  • Size of the data file,
  • Number of active records,
  • Number of deleted records,
  • Total number of records.

"External database" tab

This tab shows all the information about non-HFSQL data files present in the analysis. The following information is displayed:
  • Logical name of data file,
  • Type,
  • Data source,
  • Total number of records.

"Links" tab

This tab shows all the information about the links between the data files in the analysis.
The following information is displayed:
  • Name of the link,
  • Name the source data file,
  • Source cardinality,
  • Name of destination data file,
  • Destination cardinalities,
  • Integrity rule for deletion,
  • Integrity rule for modification.
Remark: Links are created and edited in the data model editor.
Ribbon options
When you open an analysis in the HFSQL Control Center, the ribbon shows the following options:
  • In the "Manage files" group:
    • Synchronize files: This option starts the automatic data file modification in order to synchronize the data files and their description in the analysis. This operation is performed via a wizard.
    • Add a deployment directory: This option is used to select a directory where the data files corresponding to the analysis will be sought.
    • Manage .REP files: This option lists the locations of the data files saved in the .REP file linked to the analysis. You can add files to and delete files from the .REP file.
  • In the "Files" group: This group appears for the tabs used to access data files. In particular, it allows direct access to data files. For HFSQL data files, it is also possible to launch an optimization and repair of data files.
Minimum version required
  • Version 17
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 10/02/2023

Send a report | Local help