PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Overview
  • Detailed characteristics of an HFSQL Client/Server data file
  • "Description" and "Properties" tabs
  • "Connections" tab
  • "Locks" tab
  • "Content" tab
  • "Find" tab
  • "Logs" tab
  • "Transactions" tab
  • Other available options
  • Details of 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
Overview
The HFSQL Control Center allows you to fully manage HFSQL Client/Server data files.
To display the characteristics of an HFSQL Client/Server data file:
  1. Connect (if necessary) to an HFSQL server. For more details, see Managing HFSQL Client/Server databases.
  2. Select the name of the HFSQL server in the tree structure.
  3. Select the name of the desired database.
  4. Double-click the name of the desired data file.
  5. The right section of Control Center displays a tab with the name of the data file. This tab includes:
    • several tabs used to manage the characteristics of the HFSQL data file. The "Content" tab is displayed by default.
    • a ribbon used to configure the HFSQL data file.
Remark: From the pane of Control Center, the popup menu of the data file is used to:
  • Optimize and repair the data file.
  • Close the data file.
  • Versions 22 and later
    Change the password of the data file.
    New in version 22
    Change the password of the data file.
    Change the password of the data file.
  • Delete the data file.
  • Manage the rights on the database.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Detailed characteristics of an HFSQL Client/Server data file

"Description" and "Properties" tabs

The "Description" tab displays the description of the different data file items:
  • The item name,
  • The type of the item,
  • The size of the item,
  • The type of key,
  • Whether the item is visible in "Reports & Queries".
Additional information is displayed if necessary.
Versions 26 and later
Remark: By default, items are displayed in logical order. You can use the alphabetical order if necessary via the HFSQL Control Center options:
  1. Expand the HFSQL Control Center menu ( ).
  2. Select "Options".
  3. In the window that appears, in the "Item display order" option, select "alphabetical".
New in version 26
Remark: By default, items are displayed in logical order. You can use the alphabetical order if necessary via the HFSQL Control Center options:
  1. Expand the HFSQL Control Center menu ( ).
  2. Select "Options".
  3. In the window that appears, in the "Item display order" option, select "alphabetical".
Remark: By default, items are displayed in logical order. You can use the alphabetical order if necessary via the HFSQL Control Center options:
  1. Expand the HFSQL Control Center menu ( ).
  2. Select "Options".
  3. In the window that appears, in the "Item display order" option, select "alphabetical".
The "Properties" tab displays the properties of the data file (physical name, format, protection, etc.).

"Connections" tab

This tab lists the different users connected to the data file.
The list of active connections contains the following information:
  • the user name,
  • the computer name,
  • the name of the application that accesses the database, etc.
You have the ability to manage the connections from this tab: disconnect the users or send a message to the users.

"Locks" tab

This tab is used to manage the locks.
The following information is displayed:
  • the number of the locked record,
  • the name of the user who is locking,
  • the name of the locking computer,
  • the IP address of the locking computer,
  • the name of the locking application,
  • the start date of lock,
  • the lock duration.

"Content" tab

This tab is used to view the different records found in the data file.
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 table directly. The data file is automatically modified.
The popup menu of records is also used to:
  • Delete a record,
  • Duplicate a record,
  • Specify the display options,
  • Print the records.

"Find" tab

This tab is used to perform searches in the data file. All you have to do is type the sought conditions and the values in the table of conditions.
The SQL code corresponding to the search can be copied via the "Copy the SQL code" found in the ribbon.
Remark: To perform an SQL search, click "New query" in the ribbon.

"Logs" 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 transactions.
Other available options

Details of ribbon

For the selected HFSQL Client/Server data file, the ribbon proposes the following actions:
  • In the "SQL query" group:
    • New query: This option is used to open a specific tab allowing you to perform an SQL query on the current database.
    • 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 open the configuration window for optimizing the data file.
    • Close file: this option is used to close the data file and the corresponding tab.
  • In the "Rights" group, the option "Management of rights" allows you to manage the rights granted to the users and to the groups on the data file.
Additional options may appear in the ribbon according to the selected tab.
See also
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment