|
|
|
|
|
|
|
|
HDuplicates (Function) In french: HDoublon
 Warning
HDuplicates is kept for backward compatibility (this function will still be supported in the forthcoming version). From version 8, this function was replaced by: - an automatic management of duplicates, allowing the user to enter a different value for the item generating a duplicate error.
- HErrorDuplicates.
Below is the documentation of HDuplicates, available in WINDEV 5.5
| Purpose Checking the uniqueness of a key.Syntax <Result> = HDuplicates()- <Result> is a boolean corresponding to the value of H.Duplicates.
Details When running HAdd, HModify or TableSave, if the modified or added key is not unique, H.Duplicates is set to True and the function is not run.Therefore, to find out whether if a record was modified or added, you must check HDuplicates. HDuplicates returns H.Duplicates. HDuplicates is set to True if H.Duplicates is set to True. HDuplicates is set to False if H.Duplicates is set to False. Notes - If HDuplicates is not checked while a duplicate was detected by WINDEV (when using HAdd, HModify or TableSave), the error 10 ("Duplicate on unique key") will be displayed.
Caution: this error can occur on the user computers. Therefore, don't forget to systematically check HDuplicates whenever HAdd, HModify or TableSave is used if the data file contains unique keys. - If HDuplicates and HErrIntegrity must be checked, HDuplicates must be checked before HErrIntegrity.
- If HSetDuplicatesYes is called, the management of duplicates is enabled. The management of duplicates is enabled by default.
- Reminder: WINDEV allows you to automatically create and manage an automatic identifier. All you have to do is define it during the description of the data file.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|