Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IIF in a SELECT
Message
From
09/03/2000 14:55:36
 
 
To
09/03/2000 14:44:44
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00343773
Message ID:
00343808
Views:
25
Stephane,

>I try it and it is very good !
>Maybe it is not the best solution, but I call a function() in my Select for rhe fields that I use the "iif" command.
>
>Example :
> (before)
> Select field1,iif(field2=0,0,field3/field2) as nDiv from myTable
>
> (after)
> Select field1,MyFunction("iif(field2=0,0,field3/field2)") as nDiv from myTable
>
>function MyFunction()
>lParameters tcCalcul
>return evaluate(tcCalcul)
>
>Thanks David !
>Your help was very appreciated ! :)

What is the difference in the two versions? Did we make something better? Was the first version not working for some reason?
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform