John ---

What are your two SELECT statements? I just tried the following with no problem:

SELECT * FROM mytable INTO CURSOR xxx        && Base table to cursor
USE IN mytable                               && Closes base table
SELECT * FROM xxx INTO CURSOR yyy            && Cursor to cursor

>I always though I was able to create a SQL cursor (read-only) based on previously created SQL cursor (read-only) but I guess not. I get an error something like "Must SELECT...INTO TABLE" on the second attempt. Thus, I have to do USE DBF("cursor") AGAIN... before the second SQL-SELECT statement. Any reason why?