|
|
|
|
|
- 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 database data files
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.
WDMap started from the editor For information on a database's data files: - 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).
- 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 For information on a database's data files: - 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 desired data file (use the "Browse" button if necessary) and proceed 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 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: | | Name | Comment |
---|
Logical name | Name of data 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, 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. | Replication | Indicates 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 directory | Directory of physical file. | Date of last modification | | Path of analysis in version 5.5 | Only if the selected data file comes from a 5.5 analysis. | Directory of the log | Directory of the log file associated with the selected data 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 data file. | Caption | Name 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 via | Current database access mode: 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 | Username required to connect to the database. | Access | Data file access type: read-only or read and write. | Number of records | Number of records in data file. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|