ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Tools / WDMap
  • Overview
  • How to?
  • WDMap started from the editor
  • WDMAP started by "WDMAP.EXE" directly
  • What are the displayed characteristics?
  • Characteristics specific to HFSQL data files
  • Characteristics specific to the other types of files (not in HFSQL format)
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
WDMap is used to get various characteristics specific to:
  • to each data file present in a database manipulated by a WINDEV, WEBDEV or WINDEV Mobile project,
  • all data files in a database handled by a WINDEV, WEBDEV or WINDEV Mobile project.
How to?

WDMap started from the editor

For information on a database's data files:
  1. Under WDMap, select the WINDEV, WEBDEV or WINDEV Mobile analysis (".WDD" file) containing the description of the desired data file (use the "Browse" button if necessary).
  2. Specify (if necessary) the password of the analysis (runtime password defined in the analysis description.
  3. Select "Display .. General information about the database" (or click ). The window containing the database characteristics is displayed.

WDMAP started by "WDMAP.EXE" directly

For information on a database's data files:
  1. In the wizard, select "Select an analysis" and go to the next step.
  2. Select the WINDEV, WEBDEV or WINDEV Mobile analysis (".WDD" file) containing the description of the desired data file (use the "Browse" button if necessary) and proceed to the next step.. WDMap starts.
  3. Specify (if necessary) the password of the analysis (runtime password defined in the analysis description.
  4. Select "Display .. General information about the database" (or click ). The window containing the database characteristics is displayed.
What are the displayed characteristics?
A database manipulated by a WINDEV, WEBDEV or WINDEV Mobile project can be made up of both HFSQL and non-HFSQL data files.
The window containing the characteristics is divided in half:
  • The top section contains the characteristics specific to the HFSQL data 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 consists solely of HFSQL data files, only the top part will be displayed. If the current database consists only of non-HFSQL data files, only the bottom part 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:
NameComment
Logical nameName of data file defined in the analysis.
Physical nameName of the physical file associated with the logical file. This name is defined in the analysis.
TypeHFSQL Classic or Hyper File 5.5.
Total sizeCurrent size (in KB) of the data file, the index file and the memo file corresponding to the logical file.
Number of active recordsAn active record is a record that can be used directly (by HRead for example).
Number of crossed recordsA crossed record is a record that is logically deleted (by HCross). This record can be retrieved (with <[[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, deleted and deleted records in the data file. |- | Password | Data file password set either by [[3044108|HPass]], [[3044255|HCreation]] or [[3044254|HCreationIfNotFound]], or by [[3044195|automatic data modification]]. |- | Encryption | Indicates whether the data file is encrypted. |- | Log | Indicates whether the data 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.
ReplicationIndicates whether the data 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 an HFSQL data file
File directoryDirectory of physical file.
Date of last modification
Path of analysis in version 5.5Only if the selected data file comes from a 5.5 analysis.
Directory of the logDirectory of the log file associated with the selected data file (if the log file exists).
Size of log fileCurrent 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:
NameComment
FileLogical name of data file.
CaptionName of the connection used to access the different data files found in the current analysis (specified during the configuration of the connection in the data model editor).
Connection viaCurrent database access mode: OLE DB provider, ODBC driver or native access.
Data sourceData source of the connection:
  • name and full path of the database,
  • directory of xBase file,
  • name or alias of the server used.
UserUsername required to connect to the database.
AccessData file access type: read-only or read and write.
Number of recordsNumber of records in data file.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/10/2025

Send a report | Local help