Latest Contributions by TerryGustafson

Ok, I’m stuck on what my parameters should be for the “Display Name” and “Data Type”. I’m thinking Display name is “RID” and Data type is numeric? Also the table is actually going to be in memory so will I need to set the table path? ... View more

Ok, that does work, I was trying to run the python code via the Field calculator. Is that possible? The reason I wanted to do that was I’m building a model to run a process and the second to the last step is to populate the to_MEAS so I can create a line segment. ... View more

That is my fault I copied the wrong results.. I get an invalid syntax when I select python.. ... View more

I’m trying to calculate a field based on another field in a table using python in the field Calculator. ... View more

This is an image of the errors I receive in ArcMap ... View more

Ok, made a little headway. It appears to not like the null values in the fields.  When I: replace them with 0 then it does not error out at line 1 anymore.  :It then give me the warming.  "A Field name was not found or there were unbalanced quotation marks".  I was not sure if this was due to line 21 or 15.. ... View more

I created sever types of table and set the table variable but seems to keep throwing the syntax at line 1.  Here is an example of an exported table and the code I used. table = "Export_Output" ridList = [] with arcpy.da.SearchCursor(table, ["RID"]) as cursor:     for row in cursor:         ridList.append(row[0]) del cursor ridList = set(ridList) for RID in ridList:     toMeasList = []     with arcpy.da.SearchCursor(table, ["RID", "to_MEAS"], "RID = '" + RID + "'") as cursor:         for row in cursor:             toMeasList.append(row[1])     del cursor     toMeasList.sort()     with arcpy.da.UpdateCursor(table, ["to_MEAS"], "RID = '" + RID + "'") as cursor:         for row in cursor:             row[0] = toMeasList[-1]             cursor.updateRow(row)     del cursor ... View more

I did that, the table is called result.  Does it have to be a certain type of table? ... View more

Says syntax error line 1 which is declaring the table correct? ... View more

I get a 000539 : Error message from Python. It seems like it should work. At the end its taking the row[0] array and setting the toMeasList equal to it minus 1 record correct? ... View more

I got it..  Thanks for your help./.  Have a good weekend.. ... View more

That worked but it adds a .0 to the end of the RM..  I created the RM field as a short with 0 decimal places.  So it returned C000001E156.0.  The precision is set to 4 ... View more

I tried that and it won’t work.. Not sure if it has something to do with it being a text field.. ... View more