>I have this table with almost 2,000 record and, I need to re-orde and assign a sequencial number but I need to know if I can do it with some routine not manually. And after that how I make VFoxPro auto increment.
>
>V/R
>R. De Jesus
use OldTable exclu
select * from Oldtable order by yourorder into cursor 'mytmpcursor' readwrite
replace yourSequentialField with recno() all
* if YourSeqField is a Character use Padr(alltrim(str(recno())),yourfieldleght,'0')

sele 'OldTable'
zap
appe from dbf('myTmpCursor')

* I think the last sentence works, if not create a temporary table instead of a curso in the select