>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?
The easy way out for me was:
(1) Do a SQL Select of all the data in natural order to a cursor NOFILTER
(2) ZAP the table
(3) Modify the table structure to include the AutoInc field
(4) APPEND FROM the cursor you created in (1)
As long as you don't have RI rules that cascade deletes or restrict them, it's pretty safe even for tables participating in a DBC.