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

タグ付けされた投稿をもっと見る

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

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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