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!