>Hi Grigore
>
>>Please correct me if I am wrong, but I vaguely recall SET VIEW TO does not restore the sort order as it was at the creation moment.
>
>No, when you create an environment view, the name of the controlling index tag is saved and, when the view is restored, the same index will be set.
>
>I think you may be thinking about the record pointers (which are not saved) but both the Indexes in use, and any Relations that have been defined, are preserved and restored.

Beware...

Grigore is right - the index tag is not always reset. In VFP 6 and 7 I have found if you have one or more temporary cursors open, then it's pot luck for the index tags on the other tables. Obviously, you cannot restore a cursor that doesn't exist anymore, but it makes no sense that it would affect the real tables.

I don't have VFP 8 yet to try it there.

Example:

USE table1 IN 0 ORDER TAG tag1
USE table2 IN 0 ORDER TAG tag2
SELECT * FROM table1 WHERE fld1 = value INTO CURSOR csrTemp NOFILTER
CREATE VIEW mytables
CLOSE DATA ALL
SET VIEW TO mytables

Either table1 or table2 will not have it's order restored. Run the example with just table1, and it will definitely be the one missing a set order.