Calculate Field VBA Statement If...Then...Else in ModelBuilder

Question

Hi
I am trying to build a model which calculates the fields of a colum of a table using an if...then...else statement.
After typing the expression in the Pre-Logic VBA Script Code window I tried to run the model but the fields wouldn't change values. When i do the same thing outside the model builder it works. :confused:
Why?

2nd question:
How can i populate a field with the maximum value of 3 other fields using the Field Calculator (again in Model Builder).

Thanks for your ideas!

David

JamesGonsoski · Answer

Someone who knows more about programming than I told me that the case statement should have a "case else" statement instead of just "else".  I then got it to work in both table view and Model Builder.

My bad. You are absolutely right. That example of mine should look like this:

Example 5: An alternative form is the SELECT CASE �?� CASE �?� ELSE ... END SELECT format, which seems to be a tad more consistent:

dim output as double
select case [LOCATIONID]
case 100
output = 101
case 101
output = 100
case 102
output = 104
case else
output = 0
end select

Jim

KimberlyMeinert · Answer

Someone who knows more about programming than I told me that the case statement should have a "case else" statement instead of just "else".  I then got it to work in both table view and Model Builder.

gis_KIWI4_5-1741212612538.png

JeanGroth · Answer

Hey Dave,

I have exactly the same problem with the calculator. The VBA statement works ... but not in the ModelBuilder.

Did you manage to solve the problem?

I already tried Jims statements - also not working in the modelbuilder.

Thanks,

Jean