Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Resequence table by ID number field not working?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00563636
Message ID:
00563688
Vues:
16
>I am trying to physically reorder the table by ID number starting with 1 as the first ID number at the top of the file. It would make it easier to browse the table and find certain entries from the command window that way. Perhaps there is a SORT command I can use. I will check into that. Right now my table show ranges of ID numbers when I browse such as -
>4001
>4002
>4003
>5001
>5002
>5003
>1001
>1002
>1003
>1004
>1005
>6001
>6002
>3001
>3002
>
>I would prefer to see them in sequence when I browse the table. HTH

You can select into new table, then delete the original one, and re-name this new table, if you're talking about free table. If your table is part of DBC, you can select into cursor, zap the original, then append from dbf('myCursor'). But there is no need to do it.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform