PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • Detailed characteristics of a HFSQL Classic data file
  • "Description" tab
  • "Properties" tab
  • "Content" tab
  • "Find" and "SQL" tabs
  • "Find" tab
  • "Maintenance" tab
  • "Log files" tab
  • "Transactions" tab
  • Options proposed by the ribbon
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
Managing HFSQL Classic data files
HFSQLAvailable only with this kind of connection
Overview
The HFSQL Control Center proposes a full management of HFSQL Classic data files.
To display the characteristics of a HFSQL Classic data file:
  1. Add a HFSQL Classic application if necessary.
  2. Select the name of the requested application in the "HyperFileSQL Classic" pane of Control Center.
  3. Select the name of the requested deployment directory.
  4. Select the name of the requested HFSQL Classic data file.
  5. The right section of Control Center displays the different tabs used to manage the characteristics of the HFSQL Classic data file.
The HFSQL Control Center proposes a full management of HFSQL Classic data files.
To display the characteristics of a HFSQL Classic data file:
  1. Click .
  2. The home window of the Control Center is displayed.
  3. Specify:
    • the path of the HFSQL Classic file to open,
    • its password (if necessary).
  4. Validate.
  5. The HFSQL Control Center displays the content of the selected data file. The different tabs used to manage the characteristics of the HFSQL Classic data file.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
The HFSQL Control Center proposes a full management of HFSQL Classic data files.
To display the characteristics of a HFSQL Classic data file:
  1. Display (if necessary) the home window of the HFSQL Control Center. This window is displayed:
    • when starting the HFSQL Control Center.
    • by expanding Menu option and by selecting "Open a HFSQL Classic file".
  2. The home window of the Control Center is displayed.
    HFSQL Classic files
  3. Specify:
    • the path of the HFSQL Classic file to open,
    • its password (if necessary). You have the ability to store the password.
  4. Validate.
  5. The HFSQL Control Center displays the content of the selected data file.
    • The different tabs used to manage the characteristics of the HFSQL Classic data file.
    • Versions 20 and later
      The ribbon proposes the different actions that can be performed on the file. The options may differ according to the selected tab.
      New in version 20
      The ribbon proposes the different actions that can be performed on the file. The options may differ according to the selected tab.
      The ribbon proposes the different actions that can be performed on the file. The options may differ according to the selected tab.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Detailed characteristics of a HFSQL Classic data file

"Description" tab

This tab presents the information regarding the items of the data file.
HFSQL Classic - Description tab
The following information is displayed:
  • The item name,
  • The type of the item,
  • The size of the item,
  • The type of key,
  • The statistics,
  • Whether the item is visible in "Reports & Queries".
Additional information is displayed if necessary.

"Properties" tab

The "Properties" tab displays the properties of the data file (physical name, format, protection, ...).
HFSQL Classic - Properties tab

"Content" tab

This tab is used to view the different records found in the data file.
HFSQL Classic - Content tab
The popup menu of records is used to handle the selected record: deletion, addition, display mode of the text memos, ...
You can also:
  • Delete a record: select the record and click the "Delete" button (or press the [Del] key).
  • Modify or add a record: the input is performed in the list of records. All you have to do is position on the first empty row and enter the record information. The data file is automatically modified.

"Find" and "SQL" tabs

The "Find" and "SQL" tabs are used to perform searches in the data file.
The "Find" tab is used to type the search conditions in an explicit way (QBE searches).
The "SQL" tab is used to perform a search by entering the SQL code of the query to run.

"Find" tab

The "Find" tab is used to perform searches in the data file.
The "Find" tab is used to type the search conditions in an explicit way (QBE searches). For the requested item, all you have to do is select a condition and a value to check.
HFSQL Classic - Find tab
Versions 17 and later

"Maintenance" tab

This tab is used to perform the maintenance operations on the data file (optimization, reindexing, ...).
New in version 17

"Maintenance" tab

This tab is used to perform the maintenance operations on the data file (optimization, reindexing, ...).

"Maintenance" tab

This tab is used to perform the maintenance operations on the data file (optimization, reindexing, ...).

"Log files" tab

This tab is used to view the content of the logs and to perform a search in the logs.
To do so, the data file must be logged.

"Transactions" tab

This tab is used to free a record or all the transactions.
HFSQL Classic - Transactions tab
Versions 20 and later
Options proposed by the ribbon
For the selected HFSQL Classic file, the ribbon proposes the following actions:
HFSQL Classic - Ribbon options
  • In the "SQL query" group:
    • New query: This option is used to open a specific tab allowing you to perform a query on the current data file.
    • Open a query: This option is used to open a specific tab corresponding to a query that was run beforehand.
  • In the "File" group:
    • Optimize and repair: This option is used to display the window for configuring the optimization and the repair of HFSQL files.
    • Close the file: This option is used to close the file and the associated tab.
New in version 20
Options proposed by the ribbon
For the selected HFSQL Classic file, the ribbon proposes the following actions:
HFSQL Classic - Ribbon options
  • In the "SQL query" group:
    • New query: This option is used to open a specific tab allowing you to perform a query on the current data file.
    • Open a query: This option is used to open a specific tab corresponding to a query that was run beforehand.
  • In the "File" group:
    • Optimize and repair: This option is used to display the window for configuring the optimization and the repair of HFSQL files.
    • Close the file: This option is used to close the file and the associated tab.
Options proposed by the ribbon
For the selected HFSQL Classic file, the ribbon proposes the following actions:
HFSQL Classic - Ribbon options
  • In the "SQL query" group:
    • New query: This option is used to open a specific tab allowing you to perform a query on the current data file.
    • Open a query: This option is used to open a specific tab corresponding to a query that was run beforehand.
  • In the "File" group:
    • Optimize and repair: This option is used to display the window for configuring the optimization and the repair of HFSQL files.
    • Close the file: This option is used to close the file and the associated tab.
Minimum required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment