Problem: VFP decided it was more efficient to use a filtered version of a table, rather than create a temp table on disk. This is faster, but unusable for subsequent SELECT statements.
Solution: Use the NOFILTER clause in the first SELECT statement.
>Hi
>
>I am getting an '"cursor" must be created with SELECT ... INTO TABLE (Error 1815)' when attempting to do the following
SELECT t_key, wo_id ;
FROM invcont WHERE wo_id = 345245 ;
INTO CURSOR tContInvs;
NOFILTER
...
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)