🚀 go-pugleaf

I am beginning to think I will never get to where I understand how to
use SQL in 7.0.  I have been using code like that below to attempt to
establish a temporary file, and it seems that as long as I have a
variable, in whatever form, in the SQL statement, I get a Table does not
exist error.  If, instead, I hard code a Temp.dbf, it works OK.  Please,
someone tell me what I am doing wrong, and more importantly, the
rationale for doing it the right way.  Code follows:
-- 
   Tom 
   Bena, VA

To reply email, please remove the KILL.SPAM from my address.  Not
necessary for NGs


-----------------------------------------
** END HEADER -- do not remove this line
//
// Generated on 01/24/98
//
parameter bModal
local f
f = new TempDbfForm()
if (bModal)
   f.mdi = false // ensure not MDI
   f.readModal()
else
   f.open()
endif

class TempDbfForm of FORM
   with (this)
      onOpen = class::FORM_ONOPEN
      scaleFontBold = false
      height = 16
      left = 88.4286
      top = 0.8636
      width = 40
      text = ""
   endwith


   this.FLEET1 = new DATABASE()
   this.FLEET1.parent = this
   with (this.FLEET1)
      left = 10
      top = 2
      databaseName = "FLEET"
      active = true
   endwith


   this.AIRCRAFT1 = new QUERY()
   this.AIRCRAFT1.parent = this
   with (this.AIRCRAFT1)
      left = 11.4286
      top = 2.4545
      database = form.fleet1
      sql = "select * from aircraft.dbf"
      active = true
   endwith


   this.QUERY1 = new QUERY()
   this.QUERY1.parent = this
   with (this.QUERY1)
      left = 23
      top = 2.5

   endwith


   this.rowset = this.aircraft1.rowset

   function form_onOpen 
      u = new UpdateSet()  
      u.source = form.aircraft1.rowset
      foo = funique('Temp????.dbf')
      u.destination = foo
      u.copy()
      msgbox(foo+' Exists? - '+file(foo))
      with (form.QUERY1)
          sql = 'SELECT * FROM foo'        
          active = true                // error here
      endwith
      msgbox("Done")
      return
endclass