I am having a weird problem. IIf is messing up when I am working with an array. Apparently it is checking my else statement even though it isn't activated. Here is some code that demonstrates the issue:
'works
Dim test As String = "bleh"
If values.Length < 6 Then
test = "200"
Else
test = values(5)
End If
'throws indexoutofrange exception
Dim itemLimit As String = IIf(values.Length < 6, "200", values(5))
The Iif
operator doesn't implement short circuiting and will evaluate both the true and false case. If you want a short-circuit version then use If
.
Dim itemLimit As String = If(values.Length < 6, "200", values(5))
Have a look at this article: http://www.fmsinc.com/free/newtips/net/nettip33.asp
From the article:
Visual Basic, VBA, and Visual Basic .NET support the IIF function as an alternative to the If...Then...Else statement. Although this may seem like a shortcut, IIF functions differently than If...Then...Else.
IIF must evaluate the entire statement when preparing the argument, which can lead to undesirable side effects.
In other words, your If...Then...Else
works because the Else
clause isn't being evaluated if the condition fails. The IIf
, on the other hand, evaluates all the statements, causing the IndexOutOfBounds
exception.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With