Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Resequence table by ID number field not working?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00563636
Message ID:
00563688
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform