>>MC>I'll probably need to save views, too, so that's not a problem. In my testing, even filtered cursors had a .tmp extension. How would I create one with a .dbf extension?
>
>select * from yourtable where [a very simple condition here] into cursor blabla
>
>That should give you a filtered cursor, but I'm not sure if/when would you get the dbf('blabla') equal to dbf('yourtable'). I just know I saw it a few times in VFP5 (or was it 2.6?) and I'm usually creating cursors with Nofilter whenever I need the file.
>
The exact condition that generates a filtered view rather than a cursor is a query against a single table, with no computed or added fields, that is fully Rushmore optimizable. Adding "NOFILTER" to the query, or adding an argument to the WHERE that is not Rushmore optimizable (eg add "AND .T." to the WHERE clause) to force the creation of a 'real' temporary file for the cursor.