Hi!

You should do this only after zapping a table and there are no other references to these ID's in any other table(s)

It will also depend on many other factors and you should carefully look at them and then do it or not.

As a general rule you should leave the AutoInc Columns as they are and they have to be unique i.e. Normally you would not want to reset it.

Sarosh

>Hi Sarosh
>
>That code worked but that seems a definite bug because autoincrement column loses teh unique value. if it is not unique value the purpose here, then it is fine.
>
>For example if we have 3 column with autoincrement column ID 1,2,3 then we run teh code
>Alter Table Customer Alter Column CustomerID i AutoInc NextValue 1 Step 1
>the next ID is 1 then 2 then 3 and so on.
>
>what do you think guys? Autoincrement column should be unique or not.
>
>Mo
>
>>Hi!
>>
>>Use Customer Exclusive
>>Alter Table Customer Alter Column CustomerID i AutoInc NextValue 1 Step 1
>>
>>The above command should do the trick as long as the customerid column is the autoinc column in the customer.dbf file and you have opened the customer dbf exclusively.
>>
>>Sarosh
>>
>>>Using VFP8, I would think that at least ZAP should reset the Autoincrement column. did I miss anything? or autoincrement is forever.
>>>
>>>Mo