>
><snip>
>Hey MS - Any plans to change of "fix" this.
>
>
>I agree with you,
>but it is a Function,
>and therefore it is necessary to estimate all the parameters before executing of the code.
>
>Of course VFPT can crack this standard schema,
>but i think that this event non occur on the future VFP releases.
>
>EVL() and NVL() are usefull with a :
>

>EVL(EXPRESSION,surrogateCostant or Variable)
>NVL(EXPRESSION,surrogateCostant or Variable)
>

>but if second parameter is slow to evaluate, use IIF(),
>

>IIF(ISNULL(EXPRESSION),surrogateCostant or Variable,EXPRESSION)
>

>but if EXPRESSION is slow to evalute or worse, it is not deterministic,
>you must to please you of:
>

>varExp=EXPRESSION
>IIF(ISNULL(m.varExp),surrogateCostant or Variable,m.varExp)
>

>
>Fabio

Yes I see what you mean. IIF() isn't really a single function.