WDMap: Characteristics of the files found in a database

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

Tools

WDMap

WDMap: Characteristics of the files found in a database

Overview

How to proceed?

What are the displayed characteristics?

See also

WDMap: Characteristics of the files found in a database

Overview

WDMap is used to get various characteristics specific to:

each file found in a database used by a WINDEV, WEBDEV or WINDEV Mobile project,
all the files found in a database used by a WINDEV, WEBDEV or WINDEV Mobile project.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

How to proceed?

WDMap started from the editor

To get information about the files found in a database:

In WDMap, select the WINDEV, WEBDEV or WINDEV Mobile analysis (".WDD" file) containing the description of the requested data file (click the "Browse" button if necessary).
Specify (if necessary) the password of the analysis (runtime password defined in the analysis description.
Select "Display .. General information about the database" (or click ). The window containing the database characteristics is displayed.

WDMAP started by "WDMAP.EXE" directly

To get information about the files found in a database:

In the wizard, select "Select an analysis" and go to the next step.
Select the WINDEV, WEBDEV or WINDEV Mobile analysis (".WDD" file) containing the description of the requested data file (use the "Browse" button if necessary) and go to the next step. WDMap starts.
Specify (if necessary) the password of the analysis (runtime password defined in the analysis description.
Select "Display .. General information about the database" (or click ). The window containing the database characteristics is displayed.

What are the displayed characteristics?

A database used by a WINDEV, WEBDEV or WINDEV Mobile project can include files in HFSQL format as well as files in another format.

The window containing the characteristics is divided in half:

The top section contains the characteristics specific to the HFSQL files.
The bottom section contains the characteristics specific to the other types of data files (not in HFSQL format) accessed via an OLE DB provider, an ODBC driver or a native access.

Note: If the current database only includes HFSQL files, only the top section will be displayed. If the current database only includes files not in HFSQL format, only the bottom section will be displayed.

Characteristics specific to HFSQL data files

The following table presents the characteristics displayed by WDMap. These characteristics are specific to the HFSQL data files found in the database of the WINDEV, WEBDEV or WINDEV Mobile project:

Name	Comment

Logical name	Name of the file defined in the analysis.
Physical name	Name of the physical file associated with the logical file. This name is defined in the analysis.
Type	HFSQL Classic or Hyper File 5.5.
Total size	Current size (in KB) of the data file, the index file and the memo file corresponding to the logical file.
Number of active records	An active record is a record that can be used directly (by HRead for example).
Number of crossed records	A crossed record is a record that is logically deleted (by HCross). This record can possibly be retrieved (by <[[3044042\|HModify]] or [[3044092\|HWrite]]). This record can be physically deleted (by [[3044018\|HDelete]]). \|- \| Number of deleted records \| A deleted record is a record that is deleted both logically and physically (by [[3044018\|HDelete]]). \|- \| Total number of records \| Number of active, crossed and deleted records in the file. \|- \| Password \| Password of the file defined by [[3044108\|HPass]], [[3044255\|HCreation]] or [[3044254\|HCreationIfNotFound]], or during the [[3044195\|automatic data modification]]. \|- \| Encryption \| Indicates whether the file is encrypted. \|- \| Log \| Indicates whether the file is logged. The log is a specific file used to automatically store all the operations performed on one or more data files from a given time.
Replication	Specifies whether the file is replicated. The replication is the operation used to maintain remote databases with identical structure, and on which different operations are performed.
Additional information linked to the physical file during a double click on a HFSQL data file
Directory of file	Directory of physical file.
Date of last modification
Path of analysis in version 5.5	Only if the selected file comes from an analysis in version 5.5.
Directory of the log	Directory of the log file associated with the selected file (if the log file exists).
Size of log file	Current size in KB of the log file (if the log file exists).

For all the HFSQL data files found in the database, the following calculations are automatically performed:

The total size (in KB) of all the data files.
The size (in KB) of the log files associated with the data files.
The number of records found in all the data files.

Characteristics specific to the other types of files (not in HFSQL format)

The following table presents the characteristics displayed by WDMap. These characteristics are specific to the data files not in HFSQL format found in the database of the WINDEV, WEBDEV or WINDEV Mobile project:

Name	Comment

File	Logical name of the file.
Caption	Name of the connection used to access the different data files found in the current analysis (specified when configuring the connection in the data model editor).
Connection by	Access mode to the current database: OLE DB provider, ODBC driver or native access.
Data source	Data source of the connection: name and full path of the database, directory of xBase file, name or alias of the server used.
User	User name required to connect to the database.
Access	Type of access to the file: read-only or read/write.
Number of records	Number of records in the file.