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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement