Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Autonumber keeps incrementing even when Revert
Message
From
06/11/2002 11:22:58
 
 
To
06/11/2002 11:17:35
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00719330
Message ID:
00719351
Views:
17
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform