PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • Detailed characteristics of a HFSQL Client/Server database
  • "Description" tab
  • "Connections" tab
  • "Locks" tab
  • "SQL" tab
  • "Backups" tab
  • "Maintenance" tab
  • "Rights" tab
  • "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 proposes a full management of HFSQL Client/Server databases.
To display the characteristics of a HFSQL Client/Server database:
  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. The right section of Control Center displays the different tabs used to manage the characteristics of the HFSQL Client/Server database.
Note: From the Control Center, the popup menu of the database is used to:
  • Create a new database.
  • Import a HFSQL Classic database.
  • Delete the database.
  • Duplicate the database.
The database is copied to the same server and renamed. This operation may be quite long.
The HFSQL Control Center proposes a full management of HFSQL Client/Server databases.
To display the characteristics of a HFSQL Client/Server database:
  1. Connect (if necessary) to a 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 requested 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 the HFSQL Client/Server database.
Note: From the Control Center, the popup menu of the database is used to:
  • Disconnect.
  • Import a HFSQL Classic database.
  • Start the data synchronisation.
  • Duplicate the database.
  • Delete the database.
  • Manage the rights on the database.
  • Repair the system tables.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Detailed characteristics of a HFSQL Client/Server database

"Description" tab

This tab is used to get general information about:
  • the files of the database: name, size, number of records.
  • the links.
  • the stored procedures.
  • the triggers: A trigger can be created from the Control Center ("New" button). To do so, specify:
    • the name of the trigger,
    • the procedure run when releasing the trigger,
    • the characteristics for releasing the trigger,
    • the affected data file.
  • the stored queries.
  • the parameters. They are used to store values on the server (to transmit parameters between several stored procedures for example). These parameters are managed by programming with the WLanguage functions named HSaveParameter, HLoadParameter and HDeleteParameter. The HFSQL Control Center is used to create, modify and delete parameters.

"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, ...
You have the ability to manage the connections from this tab: allow or forbid the connections, disconnect the users or send a message to the users.
The "Connection code" button allows you to get the WLanguage code used to access the database from a WINDEV, WEBDEV or WINDEV Mobile application.

"Locks" tab

This tab is used to manage the locks. The following information is displayed:
  • 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 start date of lock,
  • the duration of the lock.

"SQL" tab

This tab is used to run a SQL query on the data found in the database. To do so, enter the SQL code of the query and click "Run".
You also have the ability to copy the SQL code of a query into the clipboard.

"Backups" tab

This tab is used to perform and restore backups of the server and/or backups of databases. See Backups for more details.

"Maintenance" tab

This tab is used to re-index the data files of the database.
To perform a maintenance operation on the data files of the database:
  1. In the table, check the data files that must be processed. Specify (if necessary) the password of the files to process.
    Note: If the password is identical for all the data files, check "The password is identical for all the files".
  2. Select the options and the type of optimization to perform:
    Optimization
  3. Start the reindex operation via the "Start optimizing the indexes of selected files" button.
The available options are as follows:
  • Advanced reindexing mode
    These options are taken into account for the re-indexing operations from type 1 to type 4:
    • Delete the inactive records (deleted or crossed)
      If this option is selected, the crossed records are permanently deleted.
      Reminder: When a record is crossed, it is deleted logically and it can be retrieved later. The record is still found in the data file. Deleting the crossed records deletes these records permanently and optimizes the size of the data file.
    • Delete the damaged records
      If this option is checked, the damaged records are automatically deleted.
    • Density of the index
      Corresponds to the density rate of indexes. This rate is set to 80 by default.
      A higher rate increases the density of the index and reduces its size. In this case, the browses, searches, filters and queries are faster. The additions of records and the modifications of records may be slower.
      A smaller rate reduces the density of the index and increases its size. In this case, the browses, searches, filters and queries will be slower. The additions of records and the modifications of records will be faster.
      Caution: this parameter can be used on the data files in HFSQL Classic or Client/Server format only.
    • Character set
      The character set of the data file is kept by default. However, a re-indexing operation can be performed by changing the character set of the data file. In this case, the new character set will be taken into account during the re-index operation. The sorts, the searches, ... on string keys (strings, characters, date and time) will be performed according to this character set.
  • Options for compressing the memos
    These options are taken into account during the revision with compression of indexes and memos (option 5):
    • Keep the crossed records
      If this option is selected, the crossed records are kept. Otherwise, they are permanently deleted.
    • Attempt to retrieve data from the memo if it is damaged
      If this option is selected, WDOptimizer tries to retrieve the memo. Otherwise, the damaged records are retrieved without the associated memo.
      Caution: The memo may not be entirely retrieved. Check your data files.
  • Types of optimization
    • Option 1. Check the indexes: Checks the consistency between the index and the data files.
    • Option 2. Optimize the speed of indexes (recalculate the statistics): Optimizes the indexes by calculating statistics on the indexes. These statistics are used to optimize the filters, the queries and the HFSQL views.
      Note: The more the data file is modified, the less the statistics reflect the content of the HFSQL data file. The more records the data file contains, the less the modification of a single record impacts the overall statistics.
    • Option 3. Rebuild the indexes: Optimizes the access to the records of the data file and re-calculates the statistics. All the crossed records are automatically deleted.
    • Option 4. Rebuild the indexes and the memos: Optimizes the entire data file, its index and its memos.
    • Reindex without locking the client computers
      If this option is checked, the re-indexing operation is performed in background task and the client applications are not stopped.
      Caution: This option is taken into account for the HFSQL Client/Server data files only.

"Rights" tab

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

"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.
Note: 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 the 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.
Note: 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 the 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 a 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 required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment