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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement