Add Subtrack name attribute

Question

import arcpy
rows = arcpy.SearchCursor("E:/Arcgis/lx.gdb/testSUBorigin", "", "", "",  "VEHICLEID A; TIME A") 
arcpy.AddField_management("testSUBorigin", "SUB", "TEXT")
cursor = arcpy.SearchCursor("E:/Arcgis/lx.gdb/testSUBgetondropoffshp") 
for line in cursor:
    for row in rows: 
        if (line.VEHICLEID == row.VEHICLEID) and (line.TIME != row.TIME):
           row.SUB = "36_1"
         else:
           line.next()

Runtime error Traceback (most recent call last): File "", line 3, in File "d:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\management.py", line 3243, in AddField raise e ExecuteError: ERROR 000732: Input Table: Dataset testSUBorigin does not exist or is not supported

I want to add Subtrack point name attribute according to the get_on and drop_off points,But I don't know the mistake,and I don't know whether the idea is true.I sincerely hope someone do the similar work can help me.

Answer 1

You have an assignment in your if line rather than a logical comparison.

Change the line that says:

if (line.VEHICLEID = row.VEHICLEID) and (line.TIME != row.TIME): 

to:

if (line.VEHICLEID == row.VEHICLEID) and (line.TIME != row.TIME): 

Further, if you're using ArcGIS 10.1 or above, it's recommended that you use the arcpy.da.SearchCursor, rather than arcpy.SearchCursor