Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by clause
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01005559
Message ID:
01005581
Views:
14
IF E.Lassimilinami = .T.
* is equivalent to 
IF E.Lassimilinami 
* because E.Lassimilinami has logical value already
See code below
    SUM( IIF( E.Lassimilinami AND ( P.Iassimilid OR P2.Iassimilid ), ;
H.n100 + H.n100_2 + H.n120 + H.n120_2 , 0.00 )) totHoAs ;



>
>i don't understand.
>
>How can i write it ?
>
>bernhart
>
>
>>Bernhart,
>>
>>When variable has logical value there's no need to compare it with .T. or .F.
>>
>>    SUM( IIF( E.Lassimilinami AND ( P.Iassimilid OR P2.Iassimilid ), ;
>>H.n100 + H.n100_2 + H.n120 + H.n120_2 , 0.00 )) totHoAs ;
>>
>>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform