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

DavidJud

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.
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

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