ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Tools / WDHFDiff
  • Overview
  • Comparing two HFSQL data files
  • Comparing the structure of two HFSQL data files
  • Comparing the data found in two HFSQL data files
  • Comparing the common data files found in two directories
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
WDHFDiff - Use
Overview
WDHFDiff is used to compare:
  • the structure of two HFSQL data files.
  • the data in two HFSQL data files.
  • the common data files found in two different directories.
Comparing two HFSQL data files

Comparing the structure of two HFSQL data files

To compare the structure of two HFSQL data files:
  1. On the "Tools" tab, in the "Database" group, click "WDHFDiff".
  2. Click the "Compare 2 files" button.
  3. Select the two files to compare.
  4. Enter (if necessary) the passwords of the files to compare.
  5. Click the "Compare the structure" button. The differences found are automatically listed:
    • differences regarding the WLanguage properties of the compared files.
    • list of items found in the first file, in the second file and common to both files.
    • differences regarding the WLanguage properties of the items in the compared files.

Comparing the data found in two HFSQL data files

To compare the data found in two HFSQL data files:
  1. On the "Tools" tab, in the "Database" group, click "WDHFDiff".
  2. Compare the structure of the two data files. For more details, see the above paragraph.
  3. Click the "Compare the data" button.
  4. Select the type of comparison to perform:
    • comparison by record number. The records found in the data files will be compared according to their identifier.
    • comparison by unique key. The records found in the data files will be compared according to the unique keys common to both files.
      Remark: In this type of comparison, the crossed and/or deleted records will not be compared.
  5. Select the items to compare.
    Reminder: The "All" button is used to select all the available items. The "None" button is used to deselect the selected items.
  6. Click "OK". The differences found are automatically listed.
  7. Double-click a difference to find out its characteristics.
Comparing the common data files found in two directories
To compare the common data files found in two different directories:
  1. On the "Tools" tab, in the "Database" group, click "WDHFDiff".
  2. Click the "Compare 2 directories" button.
  3. Select the two directories to compare.
  4. Click the "Scan" button. The data files common to the two selected directories are automatically listed.
  5. Select the data files to compare.
    Reminder: The "All" button is used to select all the available files. The "None" button is used to deselect the selected files.
  6. Click the "Compare" button. The number of differences found in each data file is automatically displayed.
  7. Double-click a file to find out its differences:
    • differences regarding the WLanguage properties of the compared files.
    • list of items found in the first file, in the second file and common to both files.
    • differences regarding the WLanguage properties of the items in the compared files.
  8. Click the "Compare the data" button to perform a comparison by record number on the data files. The differences found are automatically listed.
  9. Double-click a difference to find out its characteristics.
Minimum version required
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/07/2023

Send a report | Local help