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