|
-
Nov 22nd, 2002, 07:18 AM
#1
Thread Starter
Frenzied Member
How to use parameter in "Where ...IN..." clause.
How can i use parameter in "Where...IN... Clause" ?
Consider this:
Select ID from tb1 where ID IN (1,5,7,9)
I want to use the part '1,5,7,9' as a parameter, but I dont know how. I tried to use this 'Select ID from tb2 where ID IN (?) ' in Data Adapter Configuration Wizard but i get the following error:
"OleDbCommand.Prepare method requires parameters of type '14' have an explicitly set Precision and Scale."
Any Idea?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|