🚀 go-pugleaf

In article <6o023s$ik910@forums.borland.com>, sdegenaar@yahoo.com 
grudgingly admits...
> 
> 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()
> 
> 
Mmm, did you try trimming the variable?
    location = form.rowset.fields["CHURCH"].value.righttim()
-- 
Romain Strieff [TeamB]