topic python Scripting Problem in Python Questions

python Scripting Problem

H_A_D_Padmasiri — Fri, 29 Nov 2013 04:47:12 GMT

When i run attached script. the following error message appear
Traceback (most recent call last):
File "J:\Gampaha\Scripts\Script1.py", line 70, in <module>
arcpy.CalculateField_management(inTable, "Parcelid", int(Folder_Name)*10000 + int[TextString], "VB", "")
NameError: name 'TextString' is not defined

But [TextString] is the the field in inTable

i cant understand whats wrong with the script

pl give a help

Thanks

Padmasiri

Re: python Scripting Problem

FabianBlau — Sat, 11 Dec 2021 12:22:47 GMT

Try this:

arcpy.CalculateField_management(inTable, "Parcelid", "int({0})*10000 + int([TextString])".format(Folder_Name), "VB", "")

Re: python Scripting Problem

H_A_D_Padmasiri — Tue, 03 Dec 2013 07:27:12 GMT

Dear Sir
Thank you very much for help me. I tried your code. unfortunately it gives me following error message.
Traceback (most recent call last):
File "J:\Gampaha\Scripts\Script1.py", line 72, in <module>
arcpy.CalculateField_management(inTable, "Parcelid", "(int({0})*10000 + int([TextString]))".format(Folder_Name), "VB", "")
File "c:\program files\arcgis\desktop10.1\arcpy\arcpy\management.py", line 3128, in CalculateField
raise e
ExecuteError: ERROR 999999: Error executing function.
Type mismatch: 'esri__8'
Failed to execute (CalculateField).

field Parcelid- data type is TEXT & length of 12
field Textstring- data type is TEXT & length of 255
Is it course to above error?

I check the forum but any other not reply me to different solution.

When i run script ARCcatalog locked("May be locked by another application"). is it due to wrong syntax of my script?. Is there a method to remove that lock.

Thank You

hadpadmasiri

Re: python Scripting Problem

FabianBlau — Thu, 12 Dec 2013 07:44:45 GMT

Sorry, I did python not VB.
Change "VB" to "PYTHON_9.3" and [TextString] to !TextString!.