By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,475 Members | 954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,475 IT Pros & Developers. It's quick & easy.

value list in parameter

P: n/a
Hi, i'm using a sql-select command (commandtyp:text) and the sql-query is
build with commands:

sql="... and PROD in ( :PRDCT_NAME )"
Cmd.Parameters.Add(":PRDCT_NAME", OracleType.VarChar, 0, "PRDCT_NAME")
Cmd.Parameters.Item(":PRDCT_NAME").Value = _Product

_Product contains a value list like "'a','b','c'"
an error occurs during executing the command.
where is the failure?

Thanks
jens
Apr 6 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.