W/o NOFILTER or READWRITE VFP may create a filtered cursor. It's a query's source open with USE AGAIN and filter applied to it. It cannot be used in other queries becase filters are ignored by them.

SELECT * FROM it!lotmast INTO CURSOR CURS1 NOFILTER

>
>What is wrong with this code?
>
>I'm getting
>
>"'CURS1' must be created with Select ...into table"
>
>??
>
>Thanks,
>
>Yossi
>
>

>SELECT * FROM it!lotmast INTO CURSOR CURS1
>
>tcFlCode = 'PMR12043'
>
>SELECT ex_flcode, ex_price * ex_qty * IIF(ex_factor > 0,ex_factor,1) AS sqAmount, ex_exptype ;
>	FROM it!expnsinv ;
>	WHERE ex_flcode$tcFlCode ;
>	AND ex_dlvdat >= (SELECT MIN(lm_dlvdat) FROM CURS1) ;
>	AND ex_dlvdat <= (SELECT MAX(lm_dlvdat) FROM CURS1) ;
>	INTO CURSOR cursExpenses
>