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