Error in SQL Query with Parameters in clause FROM

[Ahulane]

Hi,

 

I have a problem.

 

I want to pass a Parameter in clause FROM. But there is a probleme during the execution.

 

... FROM $P{PARAM_1} ...

 

My parameter is type of String (exemple value : param), so when i execute the program, it make automatically quotes like this :

 

... FROM 'param' ...

 

So it make a SQL error.

 

How can i do for not automatically make quote during the execution ?

[Ahulane]

I think i've find the solution.

 

... FROM $P!{PARAM_1} ...

 

(the "!")

 

Can you confirm me it is the correct option, that put "!" always remove quotes ?

 

Thanks

[mjb]

When you want to use any parameter in SQL you will need to use $P!{myParam}. This tells jasper to explicitly insert the value of the parameter into the SQL string.

 

If you wanted to pass a parameter and use it in your where clause then you would need to put the $P!{myPARAM} insides quotes.