Iif not returning value as expected

Question

I use simple if statement and would like to retrieve true or false as Boolean type. I did like this:

Iif(text = "something", Convert.ToBoolean(True), Convert.ToBoolean(False))

I was trying also this:

Iif(text = "something", True, False)

For both cases i receive false, but my expression is for sure true. What i am doing wrong?

Use `If` operator instead of old `IIf` function. The former is a (strongly typed) short circuiting operator which evaluates the second condition only if the first was `False`, the latter evaluates both always. — Tim Schmelter, Jul 17 '15 at 10:46
You should also show us the value of `text`, maybe it is `Something` or has leading/trailing spaces. — Tim Schmelter, Jul 17 '15 at 10:49

score 1 · Answer 1 · answered Jul 17 '15 at 10:59

1

Use the If operator.

    Dim someString As String = "something"
    Dim matchSomeString As Boolean = If(someString = "something", True, False)

answered Jul 17 '15 at 10:59

dbasnett

1

Why not just `Dim matchSomeString As Boolean = (someString = "something")`? – Chris Dunaway Jul 20 '15 at 15:00
Exactly! How easily I was distracted by the question, not to have seen the obvious. Thanks @ChrisDunaway – dbasnett Jul 20 '15 at 23:32

score 1 · Answer 2 · answered Jul 17 '15 at 15:58

1

For a simple Boolean value, you can use the comparison result directly

dim text as String = "something"
dim result as Boolean

result = (text ="something")

answered Jul 17 '15 at 15:58

Pablo Fébolo

score 0 · Answer 3 · answered Jul 17 '15 at 10:51

0

AS by the MSDN definition

IIF : Returns one of two objects, depending on the evaluation of an expression.

IIF function has a return value that is you need to store the True or false part to some variable.

For eg:

Dim _decision As Boolean  =IIf(text = "something", True, False);

then convert as

Convert.ToBoolean(_decision );

answered Jul 17 '15 at 10:51

Tushar Gupta

If `_decision` is declared as `Boolean` then calling `Convert.ToBoolean` on a `Boolean` is redundant. – Chris Dunaway Jul 20 '15 at 14:58
Yes @ChrisDunaway ... I just want to clear the `IIF` doubt :) – Tushar Gupta Jul 20 '15 at 18:31

score 0 · Answer 4 · answered Jul 17 '15 at 10:58

@Tushar Gupta (sorry can't comment yet, but I was about to answer any way)

You don't need to convert your value i juste tested the code below and it perfectly worked (irt was 4 and not 2 at the end of the run)

Dim irt = 2
Dim text As String = "abc"
Dim o = IIf(text = "abc", True, False)
If o Then irt = 4
End

So I guess you have not stored your return value, or your text value has not exactly the value you expect.

Anyway if you need only true/false I don't see why you are not using a simple if who would be faster.

4 Answers4