Hi Chris

From the Hacker's Guide...

"In order to do things as fast as it can, FoxPro pulls a little trick. If a query involves only a single table, has no calculated fields, is fully optimizable, and is sent to a cursor..., FoxPro simply filters the original table. "

Just add NOFILTER to the query and FoxPro will create a real cursor.

Bruce

>I have VFP 7/8/9 installed in my machine. The situation is that when I do a

select * from <table>

the result query is using the source table index file. If I go to table..Properties...in the menu, I can see the indexes of the source table and if I change the index the result query is showing the data indexed. Same happens if I used into a cursor in VFP 7/8/9 version.
>
>What is going on?