Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Autonumber keeps incrementing even when Revert
Message
De
06/11/2002 11:22:58
 
 
À
06/11/2002 11:17:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00719330
Message ID:
00719351
Vues:
18
>Micheal thanks for replying,but i dont understand you correctly, if i create another field with autonumber that will also act same, i wont be able to create a continious number,could you please explain little clearly. Thanks

A primary key, either assigned from VFP, or from one of your own routine, which is needed in all systems for having unique IDs to all records and for establishing relationships is focused on specific needs only. In some cases, from a primary key, you won't obtain a clear sequence as a primary key can also be incremented but the record is not necessary saved.

So, any custom manipulation, such as the need you expressed, is better to rely on another field such as you would rely on a field for a specific user info. Primary keys are controlled automatically, as described in the first paragraph. If you wish to force a certain control on it, in order to keep the sequence intact, you should not use it. Just create another field to take control over.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform