Re: Embedded SQL problem

[Eiresoft Software Solutions <scourtney@xxxxxxxxxxx>]

Try ..

 sql_var = '''' + '%' + %trim(craneSub) + '%' + '''';
.
.
.
.

 qcraneSub like :sql_var;



Am 2018-10-31 11:33, schrieb Danny Rodius:
> Hi All,
>
>
>
> Have a problem in understanding why one method is working and another 
> not.
>
> Try to declare a cursor with a select .. When field like ...
>
>
>
> Fields: craneSub char(10) & qcraneSub char(12)
>
>
>
> The two versions
>
> 1.	Not working
>
>
>
>         qcraneSub = '%' + %trim(craneSub) + '%';
>
>     exec sql
>
>       declare c1 cursor for
>
>         select *
>
>           from AKA0REP
>
>           where a0xhcd = :qcraneID and
>
>                 a0jxce like :qcraneSub;
>
>
>
> 2.	Working
>
>
>
>    exec sql
>
>       declare c1 cursor for
>
>         select *
>
>           from AKA0REP
>
>           where a0xhcd = :qcraneID and
>
>                 a0jxce like '%' concat trim(:craneSub) concat '%';
>
>
>
> Anyone an idea why the first option is not working?
>
>
>
> Danny