🚀 go-pugleaf

Hi all!

I have written some embedded local sql and am having no luck. I have copied
the results into a temp table just to see the results. If I use the ? I get
the right value for location in the command window, and if I replace
:location with "whatever" it also works. Can anyone see what I am doing
wrong. The value of location should be like "Adelaide".

   location = form.rowset.fields["CHURCH"].value
   locInfo = new Query()
   locInfo.sql = 'SELECT DISTINCT c.CHURCH, f.CONFERENCE, u.UNIONSDA,
d.DIVION ;
   FROM CUSTOMER AS x, CHURCH AS c, CONF AS f, SDAUNION AS u, DIVISION AS d
;
   WHERE c.CHURCH = :location
   AND c.CONFERENCE = f.CONFERENCE ;
   AND f.UNION_ID = u.UNION_ID ;
   AND u.DIV_ID = d.DIV_ID '
   locInfo.params[ "location" ] = location
   locInfo.active = true
   u=new updateset()
   u.source = locInfo.rowset
   u.destination = "temp.dbf"
   u.copy()

   Cheers!!!