Isn't the purpose of auto numbering to make sure that records are unique. So skipping numbers on occasion wouldn't be bad? If you need to know how many records you have aren't there other ways to compute that?
If a number should be sequential, maybe it should come from a separate table that is updated (incrementing a field value) as numbers are used. Hans -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Thursday, November 20, 2008 9:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Auto number reset Yes. But it would require some coding to do it. Also the consequences could be unanticipated. Suppose you renumber and you end up changing the customer number from 101 to 110. -----Original Message----- From: "Steve Breen" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 20 Nov 2008 10:44:47 -0500 Subject: [RBASE-L] - Auto number reset I have a auto number in a column in a table but there are occasions where we start to add a row to the table and then we do not add the new row, but the auto number has already been sequenced in the table. Is there any way of resetting this. Steve --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
