PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Details of available options
  • Connections
  • Description
  • Properties
  • Search
  • SQL query
  • Rights
  • Locks
  • Log
  • Maintenance
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 remote HFSQL administrator proposes a full management of the HFSQL Client/Server databases.
To display the characteristics of a HFSQL Client/Server data file:
  1. Connect to the requested HFSQL server via the remote HFSQL administrator.
  2. Select "Databases".
  3. Select the requested database and click the "Access the selected database" link.
  4. The displayed options are the options available on the current database. Click "Files".
  5. Click the name of the data file to manage. The available options are displayed.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Details of available options

Connections

This option lists the different users connected to the current data file.
The list of active connections contains the following information:
  • the user name,
  • the name of the computer,
  • the name of the application that accesses the database, ...
You have the ability to manage the connections from this page: allow or forbid the connections, disconnect the users or send a message to the users.

Description

This option is used to display the description of the different items found in the data file (name of the item, size, type, ...).

Properties

This option is used to display the properties of the data file (physical name, format, protection, ...).

Search

This option is used to perform a search in the data file. You have the ability to enter the search conditions in an explicit way.

SQL query

This option is used to perform a search in the data file. You have the ability to directly enter the SQL code of the query to run.

Rights

This option is used to manage the rights on the data file for the selected user or group.

Locks

This option 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.

Log

This option is used to view the content of the logs and to perform a search in the logs.
The file must be logged.

Maintenance

This option is used to free a record or all the transactions.
Minimum required version
  • Version 16
This page is also available for…
Comments
Click [Add] to post a comment