These are just my rules: Autonumber really should have no function other than to provide a linking mechanism to a slave table.
If you need a numbering scheme that has to be reset to 0 or 1 or have no gaps in it, then you should devise your own numbering scheme. Autonumber is good for almost 2 billion, so a less frequent rebuild due to deletions probably can be done. YMMV ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Saturday, February 16, 2008 4:17 AM Subject: [RBASE-L] - Re: Using AUTONUM in an EEP Ted, I'd guess that AUTONUM counts as changing the structure of your database which is forbidden from an EEP. Alternatively, if you have an Owner password set up you need to have that permission to change an autonumber. Regards, Alastair. ----- Original Message ----- From: Ted Lienhard To: RBASE-L Mailing List Sent: Friday, February 15, 2008 10:51 PM Subject: [RBASE-L] - Using AUTONUM in an EEP I have a form that has a button to delete rows from a table. This leaves a number missing in the sequential RNUM column that I would like to fix by renumbering using AUTONUM. When I include the AUTONUM command in the EEP, I get this error: "Autonum aborted, resource unavailable." My syntax works fine from the R> prompt. I have tried a CLOSEWINDOW to avoid any possibility of having the table already in use, but that does not stop the error. Syntax used: autonum RNUM in journal using 1 1 num Version: 7.6.3.30214 Any ideas would be appreciated! Best Regards, Ted Ted Lienhard CNE NCT Golden Valley Consulting ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.6/1282 - Release Date: 15/02/2008 19:08 --- 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. ================================================
