Versions des environnements
>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
Précédent
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