PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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 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.
Remark: 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 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 presents the information regarding the data files in HFSQL Client/Server format found 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 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 data 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 the source data file,
  • Source cardinality,
  • Name of destination data 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 "Managing files" group:
    • Synchronizing the 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 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