Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to set up a quick model that:

  1. Takes a point feature layer of development projets (a table in an access database with xy coordinates),
  2. Spatially joins polygon neighborhood designations to the feature layer,
  3. Join the output of 2 to the source feature layer (sitting as a table in access)
  4. Updates the neighborhood field based on the neighborhood field from the attributes from the spatial join

The point is that I really don't want to create a new file every time I do this, but maintain and add to the existing table of development projects.

My question is how to properly qualify field names in the field calculator so I can update values in the source table (1) based on the values of the spatial join featureclass with the neighborhood designation (2). I join the output of (2) to (1) so the attributes should all be in the same name space, I imagine.

I currently use this as my update expression (VB parser):

[PipeRealCurrent.PlanningDistrictsCombo]=[PipeRealCurrent_x_PDist.PlanningDistrictsCombo]

A field name was not found or there were unbalanced quotation marks.
ERROR 999999: Error executing function.
Item not found in this collection.
Failed to execute (Calculate Field).

enter image description here

share|improve this question

1 Answer 1

up vote 3 down vote accepted

In your expression, just use:

[PipeRealCurrent_x_PDist.PlanningDistrictsCombo]

It is incorrect to specify an assignment in the expression. You specify which field you are calculating in the 2nd parameter of the Calculate Field tool.

On another note I would suggest moving over to Python as it is better documented in the help and supports geoprocessing functions and objects which VBScript doesn't.

Rewritten in Python:

!PipeRealCurrent_x_PDist.PlanningDistrictsCombo!

See Using the Calculate Field Tool in the documentation.

share|improve this answer
    
Of course. Thanks for pointing out the assignment issue. –  ako Aug 12 '11 at 6:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.