Skip to main content

Conditional Operator in VBA/VB .NET

For most of C-like programming languages, conditional (ternary) operator is more concise than If statement. And it is also available in VBA and VB .NET.

VBA Conditional Operator

The function "IIF" exists since VB6, syntax seems like below:

Dim i As Integer
Dim s As String

i = 1
s = IIf(i > 0, "Greater than zero", "Zero or less than zero")

Debug.Print (s)
'Greater than zero

i = -1
s = IIf(i > 0, "Greater than zero", "Zero or less than zero")

Debug.Print (s)
'Zero or less than zero

It is convenient but need to notice that IIF will always evaluate all arguments. See below example:

Dim i As Integer

i = IIf(True, 1 + 1, 1*1)
'This is OK

i = IIf(True, 1 + 1, 1 / 0)
'This will throw exception due to division by zero

VB .NET Conditional Operator

To improve IIF problem, there is IF operator in VB .NET.

Dim i As Integer = 1
Dim s As String = If(i > 0, "Greater than zero", "Zero or less than zero")

Debug.Print(s)
'Greater than zero

i = -1
s = If(i > 0, "Greater than zero", "Zero or less than zero")

Debug.Print(s)
'Zero or less than zero

The syntax is similar, but the result will be only evaluated with the Boolean expression.

Dim i As Integer = If(True, 1 + 1, 1 / 0)
'This is OK because only evaluate 1+1


References:
IIf Function
If Operator (Visual Basic) | Microsoft Docs

Comments

Popular posts from this blog

aras.uiShowItemEx Method (aras Object)

aras.uiShowItemEx Method Shows Item with Item node. Syntax aras.uiShowItem( itemNd , viewMode , isOpenInTearOff ) Parameters Name Type Description itemNd Object Required. Item node. viewMode String Optional. Unknown purpose but only supports the following values: tab view (Default) openFile new ※Each supported value will get same result. Therefore, call method and pass undefined for this parameter is OK. isOpenInTearOff Boolean Optional. Specifies whether show Item with tear-off window. true - open in a tear-off window. false - open in a tab. (Default) Return Value An AsyncResult object or a Boolean. Returns AsyncResult object if the Item winodw is opened successfully, otherwise returns false. See Also aras Object Aras Innovator Client Framework

aras.uiShowItem Method (aras Object)

aras.uiShowItem Method Gets Item by Item ID and then shows the Item. Syntax aras.uiShowItem( itemTypeName , itemID , viewMode ) Parameters Name Type Description itemTypeName String Required. Name of the ItemType. itemID String Required. ID of the Item. viewMode String Optional. Unknown purpose but only supports the following values: tab view - This is default. openFile new ※Each supported value will get same result. Therefore, call method without this parameter is OK. Return Value An AsyncResult object or a Boolean. Returns AsyncResult object if the Item winodw is opened successfully, otherwise returns false. See Also aras Object Aras Innovator Client Framework

Search Tips in Aras Innovator

In "Jus Ask Innoavtor", we could learn some tips for querying data in simple search mode. But I would use those tips with examples to make it easier to understand. Suppose there are 5 records in my database. Exact String Matching Input words or terms without any special symbol will execute exact string matching. Input "A0119B/11101", 1 record returned. Input "A0119B", nothing returned. Input "11101", nothing returned. Approximate String Matching Use "*" or "%" as wildcard character to execute approximate string matching. Input "A0*", 2 records returned. Input "*1", 3 records returned. Input "*ED*", 2 records returned. Input "A*1*1", 1 record returned. Regular Expression Matching Use square brackets with simple regular expression to execute a query is acceptable, all allowed terms (which are tested by myself and refer to this article ) are sh...