ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Control Centers / HFSQL Control Center / HFSQL Client/Server
  • Overview
  • Detailed characteristics of an HFSQL Client/Server data file
  • "Description" and "Properties" tabs
  • "Connections" tab
  • "Locks" tab
  • "Content" tab
  • "Logs" tab
  • "Transactions" tab
  • Other available options
  • Ribbon details
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
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 context menu of the data file is used to:
  • Optimize and repair the data file.
  • Close the data file.
  • Change the password of the data file.
  • Delete the data file.
  • Manage the rights on the database.
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.
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, select "alphabetical" for the "Item display order" option.
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 username,
  • 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 lock start date,
  • the lock duration.

"Content" tab

This tab is used to view the different records found in the data file.
You can also filter the records displayed using the bar above the table.
The filter context menu () includes several options:
  • Apply automatically: the filter is automatically applied when you press Enter. If this option is not selected, you must apply the filter by clicking the green check mark on the right of the filter bar.
  • Remove current filter: Clears the filter bar.
  • Copy SQL code: Copies the SQL code corresponding to the filter conditions to the clipboard.
  • Create a query: Opens a "Query" tab with the SQL code corresponding to the entered conditions (same as the "New query" option in the ribbon).
  • Clear filter history: Previously used filters are automatically saved so that they can be quickly reapplied. You can clear the filter history.
The context menu of the records includes multiple options to:
  • view the record details (select the "View record" option or double-click the row). A window opens allowing you to view and edit the item values. You can use the navigation buttons to quickly view other records in the same window.
  • manipulate the selected record: delete, add, modify, etc. The data file is automatically updated. Remark: The records can be added and edited directly in the record details window.
  • configure the display options.
  • filter the current column.
  • print the record.
  • etc.

"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

Ribbon details

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 "Manage rights" option allows you to manage the rights granted to the users and groups on the data file.
Additional options may appear in the ribbon according to the selected tab.
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/05/2024

Send a report | Local help