Hi Sarosh

You are right in the process you described but I would believe that setting the Autoincrement column after zapping a table and not allowing manipulating it would make more sense.

Mo

>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