>Look this code!!!
>
>select * from mytable into cursor mycursor
>select * from mycursor into cursor mycursor2
>
>VFP return error message 'mycursor' must be created with SELECT...INTO TABLE
>
>I know if i use NOFILTER in my select - sql, the problem will be resolve!!!
>
>But i always use this syntax without problem, and since this morning i got an error message!!!
>
>I would like to know, why now this syntax does not works!!!
>
>Thanks!!!
>Martin
In my experience, you have no warranty that if the SELECT implicitly applies NOFILTER one time, it will do so every time. I had several cases of a series of SELECTs suddenly failing. Just go the safe way, and always use NOFILTER on the first SELECT.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)