PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview
  • Detailed characteristics of a HFSQL Client/Server data file
  • "Description" and "Properties" tabs
  • "Connections" tab
  • "Locks" tab
  • "Content" tab
  • "Find" and "SQL" tabs
  • "Find" tab
  • "Logs" tab
  • "Rights" 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 proposes a full management of HFSQL Client/Server data files.
To display the characteristics of a HFSQL Client/Server data file:
  1. Add a HFSQL server if necessary.
  2. Select the name of the requested HFSQL server in the "HFSQL C/S" pane of Control Center.
  3. Select the name of the requested database.
  4. Select the name of the requested data file.
  5. The right section of Control Center displays the different tabs used to manage the characteristics of the HFSQL Client/Server data file.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
The HFSQL Control Center proposes a full management of HFSQL Client/Server data files. To display the characteristics of a HFSQL Client/Server data file:
  1. Connect (if necessary) to a HFSQL server. See Managing HFSQL Client/Server databases for more details.
  2. Select the name of the HFSQL server in the tree structure.
  3. Select the name of the requested database.
  4. Then, double-click the name of the requested 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 a HFSQL Client/Server data file

"Description" and "Properties" tabs

The "Description" tab displays the description of the different data file items (name of the item, size, type, etc.).
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 duration of the lock.

"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" and "SQL" tabs

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

"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.

"Rights" tab

This tab is used to manage the rights granted to the user or to the group on the data file.
You have the ability to store and restore a configuration of rights.

"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 the 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