>Just trying out the Vpf8 beta,in my table i set logno as autoinc field and created a form using wizard for that table and when i click add the autonumber increments,but after clicking revert and then again click add the number doesn't seem to get reverted.it just keeps incrementing.
Craig is correct: the actual value shouldn't matter, just that it's unique. Besides, imagine this scenario: you add a record, assigning the next available ID to it (let's say it's 5). Then another user adds a record, getting 6 for the ID. Then you TABLEREVERT(). What should the next available ID be? Should it be 5? If so, then what happens when someone uses it? The next one can't be 6 since that's already been used.
The autoincrement feature isn't intended to be a completely sequential value without holes in the sequence. In addition to reverts, when you delete records and then pack the table, the ID values aren't renumbered, so there will be holes in the sequence in this case as well.
Doug
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only