>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