SNIP

Christof,

There have been enough reports here to convince me that VFP *will* vary in its choice of filtered vs cursor in the same SQL in the same application.


I would agree that an app which consistently gets a filtered result set could "break" if a cursor were suddenly provided and the app was running on a very low disk space system. But I am still not sure that a filtered set can be *guaranteed*. Is there something in the VFP documentation regarding this?

Cheers,

Jim N

>
>VFP follows certain rules when it creates a filtered result cursor. It won't create a filterd cursor one time, and a physical cursor another time.
>
>>In addition, if (one of) the determinants of filtered vs cursor is the size of the result set, then is it not possible that the apps in question typically work with small results sets?
>
>Why should they work on small result sets?
>
>Christof