- 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)
WDMap: Characteristics of the files found in a database
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.
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.
Remark: 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 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, 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 an HFSQL data file | | File directory | 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 via | 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. |
This page is also available for…
|
|
|
|