Mike, the parentheses are not necessary. What was wrong was the missing "IN 0". Attempting to open the DBF() of the cursor in the same work area in which the cursor itself was open caused the cursor to be closed, which deletes the temporary file, which results in the "file not found" error.
The following works fine:
SELECT * FROM myTable into cursor myCursor
SELECT myCursor
USE DBF() AGAIN IN 0 ALIAS myTable
If the cursor is not the selected work area, then you can write
USE DBF("myCursor") AGAIN IN 0 ALIAS myTable
>Hi Michelle,
>
>>USE DBF() ALIAS testcur AGAIN
>
>This needs to be
>
>
USE (DBF()) ALIAS testcur AGAIN IN 0
>
>Without the () you are looking for a file called dbf().dbf, and without the
IN 0
you actually
are closing the cursor. USE will close whatever is in the current wa and
then open the new file, thats why you can do:
>
>
USE Table SHARED
>USE Table EXCL
Rick Borup, MCSD
recursion (rE-kur'-shun) n.
see recursion.