PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → [WD22]  HModify() hIgnoreDuplicates not working
[WD22] HModify() hIgnoreDuplicates not working
Débuté par Curtis, 19 jan. 2018 20:57 - 1 réponse
#1
Posté le 19 janvier 2018 - 20:57
I have a Customer file with the field member #. Member # is a unique key. For a specific situation, I need to bypass the field being unique. I've used hIgnoreDuplicates sparingly in the past and it's always worked as expected. Now it's not. As soon as my HModify() runs I am presented with the 'Duplicate in the data' window. It says, "The value of must be unique in the database."

HModify(Customer, hRecNumCurrent, hIgnoreDuplicates)
Anyone else had this issue?
#2
Posté le 23 janvier 2018 - 10:28
Hi Curtis,

Perhaps the HFSQ user does not have the rights to manage duplicates.
You could also try hSetDuplicates()

Kind regards,
Piet
→ Revenir à WINDEV 2024