Hi Nuno do the following
ALTER TABLE mytable alter column id as integer
append data to mytable
ALTER TABLE mytable alter column id as integer AUTOINC NEXTVALUE mynextid
>Hi all!
>I have a small program used to update vfp databases. I use a empty DB and then I append from the old one. The problem is that when an AUTOINC field haven´t start from 1... Is there any easy way to disable autoinc change autoinc fiel to integer an then change agian to autoinc and establish the "Nexto value" to NNN.
>
>thank's in dvance,
>NPedro
Alexandre Palma
Senior Application Architect