A cursor may not have physical presence on a disk in which case DBF() reports none-existent file name.. A query can use a cursor name directly

	Select *, Space(5) As Lineno ;
From sbt_artran ;
Where Item != "300 " And Item != "DEL" And Item != "310" ;
		AND Item != "312" Order By 1,3 Into Cursor Tran Readwrite

>This one is quite enfuriating and any alternatives would be greatly appreciated! I am trying to run a query from a query result and all has been running fine until lately when I get a "file not found" error. Recently we added a hard drive to the machine and moved the foxtemp directory there. The dbf('sbt_artran') command shows the file should be in the e:\foxtemp directory, but I find no file there, even after a flush. Ironically, when I step through the code on the machine, it works just fine. The relevant code is below:
>**arytrn01 and artran01 are both fox tables listed in a dbc as a local view.
>the _tally is around 200,000 records.
>

>	Select Distinct invno, custno, Item, Descrip, disc, taxrate, cost, price, qtyord, ;
>		qtyshp, invdte, ponum, extprice, salesmn, terr, Class, stkcode, taxable, arstat, ;
>		glsale, glasst, Batch, taxdist, taxtype, fcreatdate From arytrn01 ;
>		unION (Select invno, custno, Item, Descrip, disc, taxrate, cost, price, qtyord, ;
>		qtyshp, invdte, ponum, extprice, salesmn, terr, Class, stkcode, taxable, arstat, ;
>		glsale, glasst, Batch, taxdist, taxtype, fcreatdate From artran01);
>		INTO Cursor sbt_artran
>
>	Select 0
>	l_sbt_artran = dbf('sbt_artran')
>	l_sbt_artran_tally = _tally
>	
>	FLUSH 
>
>	WAIT WINDOW "Creating Tran file..." TIMEOUT 60
>	
>	Select *, Space(5) As Lineno From Dbf('sbt_artran') Where Item != "300 " And Item != "DEL" And Item != "310" ;
>		AND Item != "312" Order By 1,3 Into Cursor Tran Readwrite
>

>The last line is what generates the file not found error.
>
>I haven't tried a "copy to" command from sbt_artran to see if I get the same message. I suppose I would.
>
>Any suggestions?
>
>Thanks in advance!