🚀 go-pugleaf

Romain, your a true legend!!!

Romain Strieff [TeamB] wrote in message ...
>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]