Add NOFILTER clause to your queries to force foxpro to create cursor as a temporary file that can be used in subsequent queries. See SELECT - SQL Command in the help file for details.
>Hi....I'm trying to do a series of selections into intermediate cursors, and I got this interesting error:
>
>===============
>"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.
>===============
>
>What is a "repackaged" cursor?
>What I'd like is to use these instead of tables, so I don't have to worry about cleaning up after myself. (typical....eh?)
>
>SELECT * from Blah;
> INTO CURSOR curBlah
>
>SELECT * from curBlah;
> INTO CURSOR newCurBlah;
>
>Etc.
>
>Thanks.
>
>---- Larry
--sb--