General information
Category:
Coding, syntax & commands
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only