Operator '==' incompatible with operand types 'Boolean?' and 'String'

Question

I was able to use where clause like the first one. But I get an error message when I tried to add "IS_SUBMITTED == FALSE". What do I do? IS_SUBMITTED is boolean type.

(Working)

    dsRequestList.Where = @"REQUEST_DETAIL_TYPE_ID.Contains(""" + RequestID + @""") AND  
APPROVAL_GROUP_ID.Contains(""" + ApprovalID + @""")  AND CREATE_DT >= DateTime.Parse(""" + 
FromDate + @""") AND CREATE_DT <= DateTime.Parse(""" + ToDate + @""")";

(Error) dsRequestList.Where = @"IS_SUBMITTED == """ + "False" + @""" AND REQUEST_DETAIL_TYPE_ID.Contains(""" + RequestID + @""") AND APPROVAL_GROUP_ID.Contains(""" + ApprovalID + @""") AND CREATE_DT >= DateTime.Parse(""" + FromDate + @""") AND CREATE_DT <= DateTime.Parse(""" + ToDate + @""")";

MRAB · Accepted Answer · 2012-01-27 00:58:33Z

1

Are you using "=" or "=="?

Also, doesn't this:

@"IS_SUBMITTED == """ + "False" + @""" ...

evaluate to this:

@"IS_SUBMITTED == ""False"" ...

i.e. you're actually comparing IS_SUBMITTED to the string "False" instead of False.

answered Jan 27, 2012 at 0:58

MRAB

20.7k6 gold badges44 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Hoorayo Over a year ago

I changed as "IS_SUBMITTED == FALSE"

Hoorayo Over a year ago

(I tried this way, but got same error) dsRequestList.Where = @" REQUEST_DETAIL_TYPE_ID.Contains(""" + RequestID + @""") AND APPROVAL_GROUP_ID.Contains(""" + ApprovalID + @""") AND CREATE_DT >= DateTime.Parse(""" + FromDate + @""") AND CREATE_DT <= DateTime.Parse(""" + ToDate + @""") AND IS_SUBMITTED == ""false""";

MRAB Over a year ago

That's still comparing IS_SUBMITTED with a string. Try ending it with AND IS_SUBMITTED == FALSE";.

Collectives™ on Stack Overflow

Operator '==' incompatible with operand types 'Boolean?' and 'String'

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related