PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → WB[19] restart autoID
WB[19] restart autoID
Débuté par Piet van Zanten, 29 sep. 2014 16:47 - 2 réponses
#1
Posté le 29 septembre 2014 - 16:47
Hi,

In the analysis I changed a unique key to AutoID.
After restructure, the next addition results in a duplicate error.
Webdev does not set an AutoID, it remains zero.
Addition in HFSQL Control Centre is impossible too, it sets the ID to zero an throws a duplicate error, although there's no record with an id of 0.
Modifying the ID in the dialog to the last ID+1 also throws a duplicate error.
How to make Webdev assign an AutoID from here?

Regards,
Piet
#2
Posté le 29 septembre 2014 - 16:52
Hi Piet

first, search in the existing file for the biggest value.
Then do a hadd in your file with this value+1 in the autoID field, and the forceautoID option

That's all
#3
Posté le 29 septembre 2014 - 17:58
Hi Fabrice,

I just wanted to report that I just did that and after adding and deleting a dummy record all went well.
I think that this should actually be handled by the automatic modification.
Thanks for your help anyway.

Regards,
Piet
→ Revenir à WINDEV 2024