Can I Use IN or CONTAINS in the Query Builder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

'Can I Use 'IN' or 'CONTAINS' in the QueryBuilder of the DataAdapter's
Configuration Wizard? When I use those words they are treated as text. I am
able to use 'LIKE'.

I would like to use either 'IN' or 'CONTAINS' followed by a parameter value
in the 'criteria' column of the Query Builder
 
But the nice part about the wizard is that it does the delete/insert/update
too. Do you think I can use the wizard to make a basic DataAdapter and then
just replace the SQL in the SelectCommand.CommandText?

Michael
 
You can't pass a parameter to an IN or CONTAINS operator--those values have
to be resolved when the query is compiled--not at runtime. There are ways to
get around this so search the archives.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Well, that is the only part about the wizard. What i am saying is that you
are better off doing it by hand.
 
Back
Top