Thanks Dennis I have my users run a Unload routine 2x a month, I think I will add that code in there just in case. This way my "Unload" routine will fix any possible problem.
Marc From: Dennis McGrath Sent: Monday, September 14, 2009 10:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Autonum problem If the autonum is off, the best way to fix it is to use the following syntax: AUTONUM colname IN tablename USING startnum increment NONUM Do a SELECT MAX(Colname) from tablename to find out the highest number in the column. Use the next number for startnum. CAREFUL!!! Make SURE to use the NONUM syntax. This will fix the autonumber while NOT renumbering the existing rows. Dennis McGrath -------------------------------------------------------------------------------- From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Monday, September 14, 2009 9:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Autonum problem Hi Does Unload all fix problems in Autonum? I thought it did but a user tried it and said he still had a problem. Thanks Marc
