Hello Jeffrey
I have just done the following and it seems ok.
1. Start off by adding normal integer field instead of an autoincrementing one.
2. Use replace to populate the field with numbers as required. I used the record number to get me started.
3. Take note of the highest number. (use a select max maybe )
4. Now modify the table structure again.
5. Alter the Autoincrement value to the value you noted earlier + 1
>Hi Everyone,
>
>In trying to add an autoinc data type to an existing table, it looks like I'm going to have to perform some kind of dump and reload due to the following behavior.
>
>1. Table designer doesn't add the identity values to existing records on restructure.
>2. Autoinc field is read only (can't REPLACE ALL...)
>
>Am I correct here? Any alternatives?
>
>Thanks,
>Jeff
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only