topic Re: Field Calculator VB Script in Training in GIS Questions

Field Calculator VB Script

AzaN — Thu, 31 Mar 2016 15:03:41 GMT

Hi All.

I am trying to calculating a field ([Status]) based on another field ([SymbolID]). The code that I am using is as below:

Dim Status

IF [SymbolID] = '0' THEN

Status = 'In Construction'

Else

Status = 'Planned'

EndIf

But I keep receiving failure messages. Could you please help me with that?

Thanks in advance,

Aza

Re: Field Calculator VB Script

ChristopherThomas — Thu, 31 Mar 2016 16:52:52 GMT

VB script requires double quotes.

Try:

Dim Status

IF [SymbolID] = "0" THEN

Status = "In Construction"

Else

Status = "Planned"

End If

Re: Field Calculator VB Script

AzaN — Thu, 31 Mar 2016 17:06:34 GMT

Thanks. I tried , but still gives the same message.

Re: Field Calculator VB Script

ChristopherThomas — Thu, 31 Mar 2016 17:12:29 GMT

Also, I noticed your original EndIf needs a space in it: End If

I tested it here with a file geodatabase and a sql server feature class and it worked for me. What version of ArcGIS are you using?

Re: Field Calculator VB Script

AzaN — Thu, 31 Mar 2016 17:32:54 GMT

I wonder why it doesn't work for me. I also tried different types of field (Double, Text, etc.). I work with Arc GIS 10.1.

Re: Field Calculator VB Script

DarrenWiens2 — Thu, 31 Mar 2016 17:40:25 GMT

Since you're returning text, your field must be text.

Remove the "Dim..." line. Dim is for VBA, not VBScript.

Re: Field Calculator VB Script

AzaN — Thu, 31 Mar 2016 17:47:40 GMT

Thanks. I have also tried so, but didn't work either.

Re: Field Calculator VB Script

ChristopherThomas — Thu, 31 Mar 2016 18:17:53 GMT

Here is a screenshot of what worked for me using the Calculate geoprocessing Tool in 10.3.1...

In this case SymbolID is a text field and Status is a text field length of 50 that I added to my Zoning feature class.

If you have not already, try restarting ArcGIS to make sure nothing is locked or old variables get cleared from memory.

Re: Field Calculator VB Script

AzaN — Thu, 31 Mar 2016 18:53:51 GMT

Thanks again, Christopher. I followed all the steps you mentioned. Also restarted ArcGIS, but unfortunately didn't work again. Here is a screen shot:

Re: Field Calculator VB Script

JoshuaBixby — Thu, 31 Mar 2016 19:32:47 GMT

It helps to include specific error messages, rather than just saying you got an error message.

You don't put all the code in your Expression dialog, just "Status"

Re: Field Calculator VB Script

ChristopherThomas — Fri, 01 Apr 2016 14:40:04 GMT

Aza, what Joshua Bixby said below... you only need to put the variable name "Status" into the expression. Post what the error message is if you still do not get that to work.

Re: Field Calculator VB Script

DanPatterson_Retired — Fri, 01 Apr 2016 14:43:47 GMT

time for a python example?

Re: Field Calculator VB Script

AzaN — Fri, 01 Apr 2016 15:24:01 GMT

Re: Field Calculator VB Script

ChristopherThomas — Fri, 01 Apr 2016 17:31:26 GMT

Aza,

What kind of data are you using this tool on? Is this a feature class in a file geodatabase? Excel Table?

The results window shows "CCTVs\CCTV Phase 5C\CCTV Phase 5C".

I usually try to avoid spaces in the names when scripting or gp tools are involved. I don't think that would be the problem, but you might try creating a copy with a different name without spaces and give it a try.

Chris