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
--sb--