simple da.SearchCursor error

KevinBell

Ok, I've got other da.SearchCursors that work just fine.  What up with this one???! 

import arcpy  d = {} tbl = r'E:\gis\forestry\20120711_forestryWebApp\temp.gdb\wholeCity' with arcpy.da.SearchCursor('tbl', ['rangeClass', 'count']) as c:     for r in c:  print r[0], r[1]  #d[r[0]] = r[1]   print d

Running this i get:

RuntimeError: cannot open 'tbl'
File "C:\temp\temp.py", line 5, in <module>
  with arcpy.da.SearchCursor('tbl', ['rangeClass', 'count']) as c:


Is it just that I want to jump on my moto and start riding to San Diego?!

jskinner

Hi Kevin,

You have tbl declared as a variable, and then you declare it as a string with the SearchCursor.  Try the following:

import arcpy  d = {} tbl = r'E:\gis\forestry\20120711_forestryWebApp\temp.gdb\wholeCity' with arcpy.da.SearchCursor(tbl, ['rangeClass', 'count']) as c:     for r in c:         print r[0], r[1]         #d[r[0]] = r[1]      print d