topic Re: Calculate Field Returning Error in Python Questions

Calculate Field Returning Error

MikeMacRae — Sun, 12 Dec 2021 02:48:47 GMT

Hello all. I have been having issues with running the Calculate Field tool in python. I have an older script that I used for the first time in a while and it was throwing the following error:

ERROR 999999: Error executing function.
Expected end of statement
Failed to execute (CalculateField).

I created a simple model using only the calculate field, set up a ploygon feature class with a field called "SITE" and exported to python. I ran it again, and the same error came up. I haven't been able to find a solution on the net. Can anyone suggest what I may be missing?

import arcpy
# Local variables:
TESTFC = "Z:\\Figure_Sourcing\\Figures\\Geodatabase\\TESTGDB.gdb\\TESTFC"

# Process: Calculate Field
arcpy.CalculateField_management(TESTFC, "SITE", "D01 Site", "VB", "")

Re: Calculate Field Returning Error

DarrenWiens2 — Fri, 26 Aug 2011 16:36:52 GMT

"To calculate strings to text or character fields, in the dialog box the string must be double-quoted ("string"), or in scripting, the double-quoted string must also be encapsulated in single quotes ('"string"')."

- from CalculateField help

Re: Calculate Field Returning Error

MikeMacRae — Mon, 29 Aug 2011 14:36:37 GMT

Thanks once again Darren. This solved my issue.