PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • How to proceed?
  • 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
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
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.
Note: 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:
  1. 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).
  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

To get information about the files found in a database:
  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 requested data file (use the "Browse" button if necessary) and go 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 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:
NameComment
Logical nameName of the 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 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.
ReplicationSpecifies 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 the fileDirectory of physical file.
Date of last modification
Path of analysis in version 5.5Only if the selected file comes from an analysis in version 5.5.
Directory of the logDirectory of the log file associated with the selected 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 the file.
CaptionName 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 byAccess mode to the current database: 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.
UserUser name required to connect to the database.
AccessType of access to the file: read-only or read/write.
Number of recordsNumber of records in the file.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment