SQL Parameters (SQL IN Command)

selbjx · Post by **selbjx** » Thu Apr 23, 2009 7:45 am

The sql in command works fine with oracle, however when i am executing the report nothing shows.

Where column_x In (:PARAM)

the paramter works fine if i pass it just a single value, however multiple values it stops working.

I suspect it has somehting to do with the parameter type, but very unsure.

Anyone else had any joy with the in command and parameters

Brendan · Post by **Brendan** » Thu Apr 23, 2009 8:31 am

Hi,

The following post might be able to help you:

http://forum.stimulsoft.com/Default.aspx?g=posts&t=366

selbjx · Post by **selbjx** » Thu Apr 23, 2009 9:48 am

Thought that would have solved my problem however, i dont quite understand how the {parameter} works as when i run the report it gets rejected.

I am using oracle firstly so it doesn't seem to accept @ or ? only :

If i execute query in Reports.Web and enter values (multiple values) it works fine.

Its only when passing via parameter.