When you define the auto-number column using the NONUM option, it does not renumber the existing rows, only the rows that are inserted after the column has been redefined. During loading NONUM turns the auto numbering off which is what you would do if you are reloading a table from a backup and want to maintain the existing numbers, if you use NUM, it will auto number the rows as they are loaded. If you are using the NONUM option when entering a new row, it will not generate an auto number, you need to use the NUM option (or no option as NUM is the default) if you want to auto number new rows as they are entered. Are you loading one row at a time or a you reloading from a backup? If you want to verify that your auto number column is properly defined: - go to the SYS_COLUMNS table and look up you column and find out its SYS_COLUMN_ID - go to the SYS_DEFAULTS table and verify that the columns SYS_NEXT and SYS_INCREMENTS (that match the SYS_COLUMN_ID that you got in the previous step) matches you definition. I hope this helps.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of rich Jasinski Sent: Thursday, October 03, 2002 4:02 PM To: [EMAIL PROTECTED] Subject: Autonum not working in win 6.5++ Windows 2000 I have a table that I have autonumed like: autonum orignum in match2 using 475 1 nonum When I use the load comand to load rows into the table the orignum column remains null. Any ideas? rich ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
