topic Re: simple da.SearchCursor error in Python Questions

simple da.SearchCursor error

KevinBell — Thu, 19 Jul 2012 17:53:01 GMT

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?!

Re: simple da.SearchCursor error

JakeSkinner — Thu, 19 Jul 2012 18:26:35 GMT

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

Re: simple da.SearchCursor error

KevinBell — Thu, 19 Jul 2012 19:21:24 GMT

HA HA HA HA! I knew I was getting the weekend glazed eyes! thanks!