🚀 go-pugleaf

Found it.  Check the following:

   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
      endwith
      msgbox("Done")
      return

Note the code &foo, without the dot or quotes.  However the key was also
that the FD had streamed out the database property for Query1 even
though there was no reference to the database.  When that property was
removed, the sql statement looked in the local file and found &foo, but
not foo by itself.  I am a little suprised at that, but if it works, it
works.
-- 
   Tom 
   Bena, VA

Bowen Moursund wrote:
> 
> >          sql = 'SELECT * FROM foo'
> 
> if 'foo' is a variable, try using &macro substitution, e.g.:
> 
>   sql = 'select * from "&foo."'
> ____
> Bowen Moursund (TeamB)
> bowenNOSPAM@nerds.com
> http://www.mindspring.com/~bowenm/datatech.htm

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