>Does VFP always create a temp file when creating a cursor?
>
>I'm again assuming no, (because I couldn't find them!) .If the system has enough memory, I have a feeling it is just stored in memory. This said, I've noticed that VFP creates a small(like 7K) file everytime in the temp area. What is this? My app is creating several cursors, but I only see the first one created when the app is started.
>
>Any insight?

Not much, Eugene, Beyond what Ed said, some cursors are no more than filters on the underlying table. From my experience, anything with a join condition isn't, and neither is anything that requires a calculation in the result set. What's always best is to never make any assumptions beyond these. The simplest way to check is the DBF() function. If it returns the same name as the underlying table, then it's filtered.

hth,