nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

VB Script Code block newbie question re: IF statment

PeterPeng

I get a general error for this simple code:

dim [DIAMETER_1] as number dim [New_Pipe_S] as number dim X as number  if [New_Pipe_S] = 0 then  X = [DIAMETER_1] else  X = [New_Pipe_S] end if    Final_Dia = X

[ATTACH=CONFIG]19945[/ATTACH]

IFstatementNewb.PNG

Vind meer berichten getagd met

Accepted answers

PeterPeng

nevermind, someone at Stack answered my question!

http://gis.stackexchange.com/questions/44008/field-calculator-vb-script-codeblock-if-statement-syntax-is-wrong

Thanks all!

(fyi here is the correct one)

Dim Output

If [New_Pipe_S] = 0 Then
Output = [DIAMETER]
Else
Output = [New_Pipe_S]
End If

Final_Dia =
Output

All comments

PeterPeng

DarrenWiens2

Don't "dim AS" in VB Script (if you really want to, you can dim by itself, but why bother?)

diam = [DIAMETER_1]
pipe = [New_Pipe_S]

if pipe = 0 then
 X =  diam
else
 X = pipe
end if


Final_Dia =
X

PeterPeng

I tried that and it didn't work either, same general error 99999. All 3 fields were originally formated as Long and Short Integers in ArcMap. It's stored in a shapefile and I don't have the ArcMap spatial anaylist license, if that makes a difference

?

Any other thoughts?

Much appreciated!!

IFstatementNewberrorlog.PNG

markdenil

Don't declare and use the field references as variables
declare a variable, set it to the field value, and use the variable in the code

dim diam as number
dim pipe as number
dim X as number

diam = [DIAMETER_1]
pipe = [New_Pipe_S]

if pipe = 0 then
 X =  diam
else
 X = pipe
end if


Final_Dia =
X

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.