VB.NET – IIF(,,) – Both “sides” are evaluated. What situations should I watch out for?

by

Here is the most common gotcha.

Z = iif(y=0, 0, x/y)  'Throws a divide by zero exception when y is 0

Don’t use it to avoid division by zero errors.

Another possible logic bug is when one side of the iif or the other calls a method that modifies the system state or has output parameters.

Z = iif(FunctionA(InputOutputParam), FunctionB(InputOutputParam))
'InputOutputParam is indeterminate or at least ambiguous here.

There really is no good reason to use IIF in my experience. Mostly it is just used to abbreviate code and given the problems it can cause, it just isn’t worth it. Plus, I think it makes the code harder to read.

The other thing that bites is that it returns a boxed value (ie an Object data type) which you have to cast back to the desired type.

More Related Contents:

  1. Trying to write the code to fill a field with smaller number
  2. Classes vs. Modules in VB.NET
  3. Hidden Features of VB.NET?
  4. AndAlso/OrElse in VBA
  5. Count specific character occurrences in a string
  6. How to create Control Arrays in VB .NET
  7. Add an event to all Forms in a Project
  8. ByRef vs ByVal Clarification
  9. Disable Image blending on a PictureBox
  10. How to print hidden and visible content of a Container with ScrollBars
  11. How to order list of files by file name with number?
  12. The VB.NET ‘With’ Statement – embrace or avoid?
  13. Convert a string to a datetime
  14. no value given for one or more required parameters
  15. Printing multiple pages using PrintDocument and HasMorePages
  16. Parse a string to an Enum value in VB.NET
  17. A first chance exception
  18. API for Determining if App is Running on Citrix or Terminal Services [closed]
  19. Integer.Parse vs. CInt
  20. VB.NET Checking if a File is Open before proceeding with a Read/Write?
  21. How to read a specific line from a text file in VB
  22. VB.net Need Text Box to Only Accept Numbers
  23. Automatically adjusting winform and controls to screen size
  24. VB.Net Passing values to another form
  25. DataGridView Cascading/Dependent ComboBox Columns
  26. Detecting Enter keypress on VB.NET
  27. Nothing = String.Empty (Why are these equal?)
  28. VB Detect Idle time
  29. Help with Linq and Generics. Using GetValue inside a Query
  30. What is the difference between “instantiated” and “initialized”?

Leave a Comment