I am stuck with SearchCursor and Update Cursor in my code, what's wrong with it ,
the scienrio is . I have a table in which "source" , "sink" and "duplicate" fields available.
- Search 1 in field "duplicate" , read row, save "sink" / "source" to variables.
- now initiate update cursor , row where source = sink do update .
the output in not the required one.
even I try with one Updatecursor satify the value and update rows ,
the same of the code is as :
with arcpy.da.SearchCursor(SLDTable,SLDfields) as SC01:
for SC01R in SC01:
tsource = SC01R
tsink = SC01R
with arcpy.da.UpdateCursor(SLDTable,SLDfields) as updC3:
for updC3R in updC3:
tsource = updC3R
tsink = updC3R
updC3R = sldpt + 1
updC3R = 'BL1'
updC3R = 'Yes'
sldpt += 1