PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Comparing two HFSQL data files

Comparing the structure of two HFSQL data files

To compare the structure of two HFSQL data files:
  1. Start WDHFDiff ("Tools .. WDHFDiff - HyperFileSQL comparison").On the "Tools" pane, 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. Start WDHFDiff ("Tools .. WDHFDiff - HyperFileSQL comparison").On the "Tools" pane, in the "Database" group, click "WDHFDiff".
  2. Compare the structure of the two data files. See the above paragraph for more details.
  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.
      Note: 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. Start WDHFDiff ("Tools .. WDHFDiff - HyperFileSQL comparison").On the "Tools" pane, 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 required version
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment