Joined Fields names

Question

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

OlivierOlivier · Answer

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

MathewCoyle · Answer

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")