>Hi Bruce,
>
>>Hi Jim -- I can guarentee you that Christof is not correct on this, at least not in vfp5 or 6. I just a week or so ago tested this for another thread (with Walter Meester). The simple SQL result INTO CURSOR without NOFILTER is totally unpredictable.
>
>I'm always willing to learn. *s* Can you give me a sample of such a SELECT statement?

Hi Christof - No, because it's unpredictable < s >. But what I was testing was a very basic SQL, like either of these:

Select * from mytable into cursor temp
Select * from mytable into cursor temp where myindexedfield = something

Then

USE DBF('temp') again in 0 alias RWtemp

to check for filter.

Usually I don't get a filtered table, but occasionally I do.