Does anyone know why the archive seems to end around September 2, 2008? Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293
________________________________ From: "Wills, Steve" <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Thursday, November 20, 2008 10:36:05 AM Subject: [RBASE-L] - Re: Auto number reset Steve, just in case it helps, there is a searchable archive for the list at you can search, using “autonum” for example: http://www.mail-archive.com/[EMAIL PROTECTED]&q=autonum. This little thread reminded me of it, as the discussion ranged from the somewhat conceptual/logical, i.e. what is the purpose of autonum, to the implementation-specific, such as those specific lines of code from MDRD/Marc. Since it seems that you are smokin’ away fast from the starting line, I thought this might be an additional resource for your “voyage of discovery”. HTH, Steve in Memphis From:[email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Thursday, November 20, 2008 10:23am 10:23 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Auto number reset Thanks all Will Let the gaps occur. Good advice Steve ________________________________ From:[email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Thursday, November 20, 2008 11:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 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. >> Don't do it. Let Autonumber be autonumber, and just ensure unique IDs. If you need a separate unbroken sequence for auditing purposes, generate those numbers _after_ the record is created using code. You can do that in a trigger. Still use the autonumber field to link records in different tables, but let users search (and print) the second, unbroken sequence field. -- Larry
