Eric Wilson mentioned this in the BP forum, and I thought it was worth repeating.
All these years I've been thinking that Case statements in Select blocks can take only single values. But lo! They take lists AND comparison expressions, as shown in this example from Help!
Single values and comma separated lists and value ranges and comparison expressions are all supported!
Select Case MyValue
Case 0 : Print "0"
Case 1, 2 : Print "1, 2"
Case 3 To 5 : Print "3 TO 5"
Case Is >= 6 : Print ">=6"
Case Else : Print "Else"
End Select
Actually, I knew you could use comma delimited lists of values, but I don't think I ever knew you could use ranges or formulas. Pretty awesome!
Of course, maybe all of you knew this, but if Eric and I didn't, it at least seems worth mentioning in case we are not the only two to have missed this. It seems to have been true since R4, so there shouldn't even be any nasty version dependent worries (if you have figured out how to use LotusScript pre-R4, you don't need need my help. Of course, if you are still using R3, you probably do need some professional help).
Copyright © 2004 Genii Software Ltd.