>VFP sometimes simply creates a filtered "view" on a table when you're doing a query - just like you could do with the SET FILTER (that's why they called that VFP7/8 keyword NOFILTER) command. Therefore, the result is only available in memory.
NOFILTER is available from VFP5 onwards, IIRC. I think you might be thinking about READWRITE, which *was* introduced in VFP7.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up