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:
> 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.