topic arcpy.da.searchcurson on joined table in Python Questions https://community.esri.com/t5/python-questions/arcpy-da-searchcurson-on-joined-table/m-p/298364#M23087 <HTML><HEAD></HEAD><BODY><SPAN>I have declared a searchcursor jFeatures on a joined table:</SPAN><BR /><PRE class="plain" name="code">arcpy.AddJoin_management("Output_Infrastructure_Points", "Infrastructure_OID", "ISline_lyr", "ISline_OID) jFeatures = da.SearchCursor("Output_Infrastructure_Points", "*")</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>I can see from printing out the field names (jFeatures.fields[]) that the cursor has read the joined table, but when I start reading the records in the table with a for-loop</SPAN><BR /><PRE class="plain" name="code">for jFeature in jFeatures: ....</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>or when I call the cursors next-function</SPAN><BR /><PRE class="plain" name="code">aa = jFeatures.next()</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>nothing happens. The script just jumps over this code as if no features existed in the joined table. I know by looking at the joined table in ArcMap that the join is performed successfully. So why am I not able to read the records of my joined table with the search cursor? Any idea is appreciated.</SPAN></BODY></HTML> Wed, 06 Nov 2013 14:37:51 GMT JosteinSvegården 2013-11-06T14:37:51Z arcpy.da.searchcurson on joined table https://community.esri.com/t5/python-questions/arcpy-da-searchcurson-on-joined-table/m-p/298364#M23087 <HTML><HEAD></HEAD><BODY><SPAN>I have declared a searchcursor jFeatures on a joined table:</SPAN><BR /><PRE class="plain" name="code">arcpy.AddJoin_management("Output_Infrastructure_Points", "Infrastructure_OID", "ISline_lyr", "ISline_OID) jFeatures = da.SearchCursor("Output_Infrastructure_Points", "*")</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>I can see from printing out the field names (jFeatures.fields[]) that the cursor has read the joined table, but when I start reading the records in the table with a for-loop</SPAN><BR /><PRE class="plain" name="code">for jFeature in jFeatures: ....</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>or when I call the cursors next-function</SPAN><BR /><PRE class="plain" name="code">aa = jFeatures.next()</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>nothing happens. The script just jumps over this code as if no features existed in the joined table. I know by looking at the joined table in ArcMap that the join is performed successfully. So why am I not able to read the records of my joined table with the search cursor? Any idea is appreciated.</SPAN></BODY></HTML> Wed, 06 Nov 2013 14:37:51 GMT https://community.esri.com/t5/python-questions/arcpy-da-searchcurson-on-joined-table/m-p/298364#M23087 JosteinSvegården 2013-11-06T14:37:51Z