PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HFSQL Control Center: Opening an analysis
Overview
The HFSQL Control Center proposes a full management of 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" pane, in the "Database" group, click "HFSQL".
    3. The home window of the HFSQL Control Center is displayed. The option "Open an analysis" is selected and the path of the analysis found in the current project is specified.
      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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Characteristics of the analysis

"HFSQL Classic" tab

This tab presents the information regarding the data files in HFSQL Classic format found in the analysis. The following information is displayed:
  • Logical name of the file,
  • Full path (if it exists),
  • File size,
  • Number of active records,
  • Number of deleted records,
  • Total number of records.

"HFSQL C/S" tab

This tab presents the information regarding the data files in HFSQL Client/Server format found in the analysis. The following information is displayed:
  • Logical name of the file,
  • Server,
  • Associated database,
  • File size,
  • Number of active records,
  • Number of deleted records,
  • Total number of records.

"External database" tab

This tab presents the information regarding the data files in a format other than HFSQL found in the analysis. The following information is displayed:
  • Logical name of the file,
  • Type,
  • Data source,
  • Total number of records.

"Links" tab

This tab presents the information regarding the links between the data files found in the analysis.
The following information is displayed:
  • Name of the link,
  • Name of source file,
  • Source cardinality,
  • Name of destination file,
  • Destination cardinalities,
  • Integrity rule for deletion,
  • Integrity rule for modification.
Note: The creation and the modification of links are performed in the data model editor.
Ribbon options
When opening an analysis in the HFSQL Control Center, the ribbon proposes the following options:
  • In the "File management" group:
    • Synchronizing files: This option is used to start the automatic modification of data files 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.
    • Managing the .REP: This option is used to list the locations of the data files saved in the .REP file linked to the analysis. You have the ability to add files into .REP and to delete files from .REP.
  • In the "Files" group: This group appears for the tabs used to access the files. It is mainly used to access the files directly. For the HFSQL data files, you also have the ability to start an optimization and a repair for the files.
Minimum required version
  • Version 17
This page is also available for…
Comments
Click [Add] to post a comment