Jasper report and query in query

[2004 IR Help]

By: nanoua4 - nanoua4

Jasper report and query in query

2004-10-21 02:24

Hello,

i use a query as this:

select * from engagements where

( ENGAGEMENTS.ID_TIERS in (select TIERS.ID_TIERS

FROM TIERS WHERE TIERS.CODE_TIERS like $P{p_code_tiers} )),

an error is generated Sql exception ...

 

Thanks for help

 

 

 

 

By: Rick Millar - rmillar

RE: Jasper report and query in query

2004-10-21 08:45

I assume that you've tested your query outside of i-reports and it works fine. If so, then try putting an exclamation point after the "P" in your parameter reference: $P!{p_code_tiers}.