Passsing parameters in where .. in ( ) clause [message #81589] |
Tue, 04 March 2003 11:19 |
Felix Murillo
Messages: 2 Registered: March 2003
|
Junior Member |
|
|
My report is based on a table from which I want to filter a few records based on the passing emp. codes.
I am calling the report from the form itself. This form contains a grid that selects the codes. The codes are passing to the report in a varchar variable, ex: ('890-A','900-B'). The select "select sob_numexp from tfsvsoloblig
where sob_numexp :ex_where" fails if it passed more than one value.
|
|
|
|