>>>"cursor" must be created with SELECT ... INTO TABLE (Error 1815)
>>>
>>>You have tried to use a repackaged cursor as a source for another SELECT statement.
>>>
>>>· Some cursors cannot be used in successive queries.
>>>
>>>Use the INTO TABLE clause of the SELECT - SQL statement instead.
>>
>>I'm going to take a wild guess here (not having seen the same error myself), and assume that you did a SELECT which resulted in a filtered table, rather than a temporary file. You can try SELECT...INTO CURSOR crsrTable NOFILTER, and VFP will be quite happy. (At least, 5 will -- I'm not sure about 3.)
>
>the NOFILTER clause is new to 5.0 in 3.0 or 2.x you have to do something like add or rename a field or something similar
>
>Arnon
BTW I cannot find NOFILTER clause in VFP5.0 manual!?
Edward Pikman
Independent Consultant