Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IIF in a SELECT
Message
 
To
09/03/2000 13:36:55
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00343773
Message ID:
00343778
Views:
18
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
Ronald L. Thorp
http://www.Fox-Pros.com
Fox-Pros, Inc.
Office 407-498-0100
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform