Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change record order permanently
Message
 
 
To
06/02/2007 10:34:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01192768
Message ID:
01192807
Views:
12
>Dear Naomi
>
>You wrote
>
>select myTable
>set order to ISeq
>copy to MyNewTable
>
>I do not copy to another table.
>Suppose I index my table. Then I quit visual foxpro.
>Again all records must be displayed in previous index order as shown in my example.

USE myTable ORDER TAG iSeq

In other words, always open the table with the index tag you created and you would see records in the correct order.

There is nothing more to that, the physical sort would not change.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform