ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Control Centers / HFSQL Control Center / HFSQL Client/Server
  • Overview
  • Detailed characteristics of an HFSQL Client/Server database
  • "General" tab
  • "Connections" tab
  • "Scheduled elements" tab
  • "Backups" tab
  • "Links" tab
  • "Stored procedures" tab
  • "Triggers" tab
  • "Stored queries" tab
  • "Parameters" tab
  • "Locks" tab
  • Ribbon options
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 databases.
To display the characteristics of an HFSQL Client/Server database:
  1. Connect (if necessary) to an HFSQL server. For more details, see Managing HFSQL Client/Server databases.
  2. In the tree structure of the Control Center, expand the server and its databases.
  3. Double-click the name of the desired database.
  4. A new tab corresponding to the name of the selected database is displayed. A ribbon and different tabs are used to manage the characteristics of HFSQL Client/Server database.
Remark: From the Control Center, the context menu of the database is used to:
  • Disconnect.
  • Import an HFSQL Classic database.
  • Start the data synchronisation.
  • Duplicate the database.
  • Delete database.
  • Manage the rights on the database.
  • Repair system tables.
Detailed characteristics of an HFSQL Client/Server database

"General" tab

This option is used to get general information about the files found in the database: name, size, number of records.
By default, only the names of the data files are displayed.
The context menu of the files is used to:
  • Display the file details. The displayed information is calculated and updated for the file.
  • Access the file. The file content is displayed in a new tab.
  • Optimize and repair the file.
Remark: The " Hide backup directories " option shows only the directories containing the data files from the database.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Files" group, are used to:
  • Access file: This option is used to open a new tab displaying the characteristics of the selected file.
  • View details: This option is used to display the details of selected files in the database tab.
  • Optimize and repair: This option is used to display the window for configuring the optimization and the repair of HFSQL files.
  • Delete: This option deletes the selected files.

"Connections" tab

This tab lists the different users connected to the database.
The list of active connections contains the following information:
  • the username,
  • the computer name,
  • the name of the application that accesses the database, etc.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Connections" group, are used to:
  • allow or forbid the connections,
  • disconnect the users,
  • send a message to the users.
The option "Don't display the connections of HFSQL Control Center (stated on this computer)" is used to only display the connections of users via the applications.

"Scheduled elements" tab

This tab is used to create, modify and delete schedule operations for the database:
  • backups.
  • tasks (stored procedures).
  • optimization.
  • refresh of materialized views.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Scheduled elements" group, are used to:
  • create a new scheduling,
  • display the details of a scheduling,
  • run a scheduling,
  • delete a scheduling.
For more details, see Managing scheduled tasks.

"Backups" tab

This tab is used to perform and restore database backups. This tab lists the database backups:
  • currently run,
  • ended.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Backups" group, are used to:
  • create a new backup (hot or scheduled backup),
  • restart a backup,
  • restore a backup,
  • delete a backup.
For more details, see Backups.

"Links" tab

This tab presents the information regarding the links between the data files found in the HFSQL Client/Server database.
The following information is displayed:
  • Name of the link,
  • Name of source file,
  • Source cardinality,
  • Name of destination file,
  • Destination cardinalities,
  • Integrity rule for deletion,
  • Integrity rule for modification.
Remark: Links are created and edited in the data model editor.

"Stored procedures" tab

This tab lists the different sets of stored procedures and the stored procedures of current database.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Stored procedures" group, are used to:
  • Update the sets of stored procedures.
  • Delete a set of stored procedures.
For more details, see Stored procedures and queries.

"Triggers" tab

This tab lists the different triggers of the current database. You can get:
  • The name of the trigger,
  • The data files affected by the trigger,
  • The stored procedure called when releasing the trigger,
  • The HFSQL functions for releasing the trigger.
  • The type of trigger (before/after)
The trigger can be enabled or disabled by clicking in the check box of the "Active" column.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Triggers" group, are used to:
  • create a new trigger.
  • modify a trigger.
  • delete a trigger.
For more details, see Server triggers.

"Stored queries" tab

This tab lists the different stored queries and the stored procedures of the current database.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Stored queries" group, are used to delete a stored query.
For more details, see Stored procedures and queries.

"Parameters" tab

This tab lists the different paramters of the current database.
The parameters are used to store:
  • The date and time of the last user connection,
  • The environment parameters of an application,
  • The status report of a stored procedure,
  • etc.
For each paramteter, you have the ability to find out:
  • The parameter name,
  • The parameter value.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Parameters" group, are used to:
  • create a new parameter.
  • modify a parameter.
  • delete a parameter.
To handle the database parameters through programming, you have the ability to use HSaveParameter, HLoadParameter and HDeleteParameter.

"Locks" tab

This tab is used to manage the locks for all the data files of the current database.
You can find out:
  • the name of the file onto which the lock is applied,
  • 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 type of lock,
  • the lock start date,
  • the lock duration.
This information can be retrieved through programming with HInfoLock.
To unlock a record from the HFSQL Control Center, you must disconnect the user who locked the record.
To disconnect users:
  1. Display the database pane (double-click its name in the tree structure).
  2. Click the "Connections" tab.
  3. In the ribbon, in the "Connections" group, click "Disconnect users".
  4. In the window that is displayed, check the users to disconnect.
  5. Click "Disconnect the selected users".
Ribbon options
For the selected HFSQL Client/Server database, 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 a 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 "Databases" group:
    • Import an HFSQL Classic database
    • Copy files from the server
    • Synchronizing the database
    • Duplicate database
    • Close connection to the database
  • 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 database.
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2023

Send a report | Local help