VFP cannot create filtered cursor when query involves more than one table. Basic requirements for filtered cursor:
- Only one table is referenced by query
- WHERE condition is optimisable and can be represented by SET FILTER TO
- Either all fileds from the table are selected or subset of fields can be limited by SET FIELDS command



>Thanks. In fact the VFP help says:
>
>

>NOFILTER creates a cursor that can be used in subsequent queries.
>

>
>So why does this work:
>
>

>SELECT Lotmast.lm_flcode FROM ;
>    it!lotmast ;
>    INNER JOIN it!flckmast ;
>   ON  Lotmast.lm_flcode = Flckmast.fm_flcode ;
>   WHERE SUBSTR(lm_flcode,5,4) >= '2026' ;
>   INTO CURSOR curs1
>
>  SELECT * ;
>  fROM curs1 ;
>  INTO CURSOR curs1a
>

>
>Thanx-
>Yossi