>James,
>
>When you do a simple query (no joins, no calculated fields) VFP sometimes just does a USE AGAIN on the table you select from and sets a filter on it. In this case you cannot do a SELECT from the resulting cursor because SELECT ignores any filter.
>
>If you're using VFP 5 or higher, use the NOFILTER keyword like this:
>
>SELECT * ;
> FROM mytable ;
> WHERE ... ;
> INTO CURSOR mycursor NOFILTER
If you're using VFP 3.0 or earlier, just create a dummy calculated field:
>
>SELECT *, ' ' AS Dummy ;
> FROM mytable ;
> WHERE ... ;
> INTO CURSOR mycursor
Either method will force VFP to create a new temporary dbf to hold the cursor instead of just filtering the original table.
>
An alternative in VFP 3 would be to add something simple to the WHERE clause that isn't Rushmore optimizable; I've found that adding
AND .T. to the WHERE clause accomplished the same thing as adding the calculated field, without changing the structure of the resulting cursor.
>>Anyone know what this means: (Error 1815) cursor must be created with SELECT INTO TABLE?
>>
>>I am attempting to select from a cursor into a second cursor as the datasource for a report.
>>
>>Until today it worked. Now I get this strange error message.
>>
>>Evidently Select is not finding the source cursor -- even though it is the table returned by ALIAS() at the point where the second select commences.
>>
>>Any ideas would be appreciated.
>>
>>Regards,