[Criel]

Hello,

I recently started a new job in IT and have been looking at their code for the past week or two and noticed they use the IIF function alot. I've never seen it and wasn't taught it in school - are there any benefits to using this rather than an if/else rather than to save lines of code?

edit: IIF function*********

This post has been edited by Criel: 21 November 2011 - 03:16 PM

[modi123_1]

Depends where you are using it at... say in reporting services that's their short hand for doing an if-else statement in a cell. Same with dataset's columns as well.

No particular advantage - just different syntax.

[m_wylie85]

I would guess it would depend on what they are trying to achieve with there code. It's hard to say what is better without knowing what the code is doing i would suggest reading up on IF statement then go and read their code and come to you own conclusion.

Whoops modi beat me to it

This post has been edited by m_wylie85: 21 November 2011 - 03:23 PM

[born2c0de]

Another advantage of IIF() is that it improves code readability when used appropriately.

[modi123_1]

Haha.. or destroys it with some overly complex data column's "Expression". Ugh.. Nest about twelve (or more) of those together and you'll know pain.

[AdamSpeight2008]

IIF is a throwback to vb6, thus has to maintain compatibly.

It has the side-effect (read as problem) that it evaluates both side of the statement before deciding which to use.

If has single line overload, evaluates only the require statement.

Dim x=If( condition, onTrue, onFalse)

This post has been edited by AdamSpeight2008: 21 November 2011 - 03:40 PM