Re: Embedded SQL problem

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