PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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. See Managing HFSQL Client/Server databases for more details.
  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 popup menu of the database is used to:
  • Disconnect.
  • Import an HFSQL Classic database.
  • Start the data synchronisation.
  • Duplicate the database.
  • Delete the database.
  • Manage the rights on the database.
  • Repair the system tables.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
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 popup 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 option "Hide the backup directories" is used to only display the directories containing the data files found in 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 the file: This option is used to open a new tab displaying the characteristics of the selected file.
  • Display the 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.

"Connections" tab

This tab lists the different users connected to the database.
The list of active connections contains the following information:
  • the user name,
  • the computer name,
  • the name of the application that accesses the database, ...
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.
See Managing the scheduled tasks for more details.

"Backups" tab

This tab is used to perform and restore backups of databases. 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.
See Backups for more details.

"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: The creation and the modification of links are performed 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.
See Stored procedures and queries for more details.

"Triggers" tab

This tab lists the different triggers of the current database. You can find out:
  • 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.
See Server triggers for more details.

"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.
See Stored procedures and queries for more details.

"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 by 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 start date of lock,
  • the duration of the lock.
This information can be retrieved by 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 the database
    • Close the 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