General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
How can I easily sort a table based on the primary key?
I wrote some FoxPro 6 code a few years ago (now with SP5) and now the client has a fair amount of data in the DB. I would like to resort most (or all) of the tables in that DB based on the primary key of each table.
I have spent the last 2.5 hours goofing with SORT, COPY STRUCTURE, APPEND FROM... and combinations there of. In the end all I ended up with was frustration. I am certain that I ran a couple of simple commands when I imported their old data into the 'new' database a few years ago but I just can not seem to figure out the process. Surely, there is an easy way to do this.
Any suggestions would be appreciated.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only