Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Re Sorting Tables
Message
From
30/04/2002 17:52:51
Ian Matthews
Up & Running Technologies Inc
Chestermere, Alberta, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re Sorting Tables
Miscellaneous
Thread ID:
00651133
Message ID:
00651133
Views:
50
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
Map
View

Click here to load this message in the networking platform