If statement I never seen before

ggarze · Post by **ggarze** » Fri Mar 25, 2011 2:49 pm

Just started a new job and looking over an IF statement that in my 7 years I've never seen before. Can someone explain to me what's going on in this statement. I never knew you can end an IF statment with a then and else then do another statement then else. I've always seen If then Else If then ...

If Not( If Len(Trim(svINPUTFIELD)) = Count(svINPUTFIELD,' ') Then 0 Else 1) Then TrimF(TrimB(svINPUTFIELD)) Else svINPUTFIELD

Thanks

chulett · Post by **chulett** » Fri Mar 25, 2011 3:13 pm

It's basically just your normal if-then-else, it's just that the if side has a self-contained if-then-else inside it, one that resolves to true or false.

ggarze · Post by **ggarze** » Mon Mar 28, 2011 3:01 pm

Thanks Craig - so if I understand correctly:

0 = true "Then TrimF(TrimB(svINPUTFIELD))"
1 = false "Else svINPUTFIELD"

chulett · Post by **chulett** » Mon Mar 28, 2011 3:04 pm

Other way 'round, actually. 0 is false and (technically) any non-zero value evaluates as true, including the 1 used here.