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
