using sql query in VB datareports
i am developing datareports with data environment and backend as oracle 9i.
i have to use the query like
"select * from det where name in (parval)"
but im not able to pass multiple values to parval like parval=23,34,45 or parval='23','34','45'.it is not accepting.
but the same query runs well from oracle 9i sql prompt.
do anyone have an idea of how to pass multiple values to a datareport command parameter?
thanks in advance