The wait window is evaluating correctly. The Value is 2 to if fires the first choice. if you want to fire the test fuction change the 2 to a 5 and it will fire.
Ron
>I have a problem with the command IIF() in a select.
>
>--> IIF(lExpression, eExpression1, eExpression2)
>
>Even if the lExpression is evaluate to .t., the code in the eExpression2 is executed in a select, but not in a command like wait window ?
>Why ?
>
>-- I always thought that it was not supposed to be execute !
>
>Try this and you will see the problem :
>
>create cursor curTest (cValue integer)
>select curTest
>insert into curTest values(2)
>
>* This code will not execute the function test
>wait window iif(cValue=2,"it will not execute the function",test()+"it will execute it")
>
>* This code will execute the function test """ 2 TIMES """????
>select iif(cValue=2,"it will not execute the function",test()+"it will execute it");
> from curTest
>
>close table all
>
>function test()
> = Messagebox("function test")
>return ""
>
>Did somebody know how to correct that error ?
>Thanks in advance !!
>
>Stef