Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
weitzhandler
Yak Posting Veteran
64 Posts |
 Posted - 2008-01-28 : 23:10:18
|
| hello everybody!I'm using ssce.I'm trying to add the followed query in my table adapter but in the query builder (VS), when I choose execute query, I get a couple of textboxes but whatever I type in, I get an error message "The parameter is wrong" here is the query:SELECT EntryID, UserInfo, Kind, ActionDate, Span, SalaryAtActionFROM LogbookWHERE((CASEWHEN @Enter = 0 AND @Exit = 0 THEN 0WHEN @Enter = 1 AND @Exit = 0 AND kind = '?????' THEN 1WHEN @Enter = 0 AND @Exit = 1 AND kind = '?????' THEN 1 WHEN @Enter = 1 AND @exit = 1 AND kind IN ('?????', '?????') THEN 1 ELSE 0 END) = 1)what I try to implement is, a table that one of it's columns is bit datatype. the end-user can filter out the table by these parameters whether to show only the true rows or only the false rows or both.would you suggest to use a different various of the query?(a help button is provided on the error message, it refers to ][url]ms-help://MS.VSCC.v90/MS.MSDNQTR.v90.en/dv_vdt03/html/f0bf6b59-c245-4340-a869-5d7278fe0ae5.htm[/url] in case it helps anybody).Shimi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-29 : 01:38:44
|
| What are this '????''s? are you trying to use ? as placeholder for params? |
 |
|
|
|
|
|
why don't this little query work for me