Select to view content in your preferred language

Joined Fields names

602
2
03-05-2012 09:13 AM
OlivierOlivier
Regular Contributor
Hi,

With 10.0, I thought it was possible to use directly field names instead of getvalue/setvalue to get fields values. Problem comes with joined layer :

I use rows=searchCursor("joined layer") and try for row in rows...

If I use the field name only (row.field_name), it's unknown, and if I use row.table_name.field_name, I get the error field "table_name" is unknown. I tried to set arcpy.env.qualifiedFieldNames either to True of False, but nothing worked out. Perhaps I need to set other delimiters ?

Thanks for any help

Olivier
Tags (2)
0 Kudos
2 Replies
MathewCoyle
Honored Contributor
For joined tables you still have to use the getVaue statement I am fairly certain.

cur = arcpy.SearchCursor(layer)
for row in cur:
     row.getValue("JoinedTableName.FieldName")
0 Kudos
OlivierOlivier
Regular Contributor
Hi Mathew,

Thanks, I hoped it could solve this problem of querying joined fields which works with SearchCursor but not with UpdateCursor... Never mind !

Olivier
0 Kudos