>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.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.