help with IFF statement in SELECT 1

[Judi201]

Hi!

I just can't seem to get this. I have the following code in the old DOS FOX app I am reworking in VFP 6.0

IF shiptotl <= purtotl
   ordrreq = purtotl - shptotl + shipped
ELSE 
   ordrreq = shipped - (shptotl-purtotl)
   IF ordrreq < 0
       ordrreq = 0
   ENDIF 
ENDIF

I am trying to include this in a SELECT to set up a report. This is what I am trying; but even tho I don't get any kind of error, the cursor does not show 'ordrreq'

SUM(IFF((orders.shiptotl <= purtotl),;
    (purtotl - (shptotl + orders.shipped)), ;
    (orders.shipped -(shptotl - purtotl))))   AS ordrreg ;

I would really appreciate it if someone would give me a push in the right direction.

Thanks as always.

Judi

 

[Judi201]

Well..... I meant IIF instead of IFF in the code above.
Sorry.

Judi

 

[Judi201]

Mike,

I caught the error I posted on the IIF before I saw your reply , honestly but not the 'q'. Glad to know I was thinking right, anyway.

Thanks for the sharp eyes and your time. I fixed that and it is working fine.

Judi