Same python code works in arcgis python window, but fails in pyScripter

Question

This code works in the arcgis python window but in PyScripter, this warning message had been written:

Traceback (most recent call last): File "", line 16, in File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy_init_.py", line 1167, in SearchCursor return gp.searchCursor(dataset, where_clause, spatial_reference, fields, sort_fields) File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\geoprocessing_base.py", line 359, in searchCursor self._gp.SearchCursor(*gp_fixargs(args, True))) IOError:

import arcpy
arcpy.env.workspace = r"C:\Desktop\spatial statistics analysis tutorials\PatternAnalysis\PatternAnalysisExercise\DengueData.gdb"

# place all the rows from the feature class into a search cursor
cursor = arcpy.SearchCursor("IndCases")

# iterate through the cursor and print the attributes to the interactive window
# print it in a standard three line format
for row in cur:
    print row.AGE

I was wondering why this situation happened, any suggestions?

Answer 1

It could be an issue with the workspace path. if this is a win7 machine, i would not typically expect to see a path like

arcpy.env.workspace = r"C:\Desktop\spatial statistics analysis tutorials\PatternAnalysis\PatternAnalysisExercise\DengueData.gdb".

Instead, i would expect a path like

arcpy.env.workspace = r'C:\users\YourUserName\Desktop\...'

in a quick test, i found that arcpy will happily set the workspace to a non-existent path- only to later fail because it can't find the feature class.

Answer 2

1) You create a SearchCursor object which is assigned to the variable cursor:

# place all the rows from the feature class into a search cursor
cursor = arcpy.SearchCursor("IndCases")

But then you try to access this using the variable cur, which doesn't exist:

for row in cur:

Try using for row in cursor instead.

2) See the arcpy.da.SearchCursor help file for a better way to handle cursors in ArcGIS 10.2 and above:

with arcpy.da.SearchCursor(fc, fields) as cursor:
    for row in cursor:
        print(row)