topic Re: Problem with Delete Field in Geoprocessing Questions

Problem with Delete Field

DanielDillard — Mon, 17 Jan 2011 14:43:17 GMT

Hi all,

I am attempting to delete fields from a result table of the ZoneStatisticsAsTable tool.

Here is the script in python:

import arcgisscripting

gp = arcgisscripting.create(9.3)

table = "C:\GISDATA\resultTable"

fields = gp.ListFields(resultTable)

for field in fields:
    if ((field.name != "BUILD_ID") and (field.name != "MAX")):
        gp.deletefield(table, field)

I get:

RuntimeError: Object: Error in executing tool.

I tried running the deleteField tool on the same table in the command line in ArcMap and got an error saying the table does not exist or is not supported.

I am able to manually delete fields on this table in ArcMap.

At this point I am going to find another way to accomplish my goal. I am just curious as to why this isn't working.

Re: Problem with Delete Field

DanPatterson_Retired — Mon, 17 Jan 2011 15:53:22 GMT

table = "C:\GISDATA\resultTable"

is incorrect, it must be
table = r"C:\GISDATA\resultTable"
or
table = "C:\\GISDATA\\resultTable"
or
table = "C:/GISDATA/resultTable"
and I suspect that a file extension is also needed

Re: Problem with Delete Field

ColinZwicker — Tue, 09 Aug 2016 19:03:10 GMT

I think you will also then need to pass that to the list fields

fields = gp.ListFields(table)

instead of

fields = gp.ListFields(resultTable)

note: if that table is a shapefile attempting to delete a required field (e.g., FID) should also fail.

Re: Problem with Delete Field

DanPatterson_Retired — Sat, 11 Dec 2021 22:30:36 GMT

Well after 6 years I doubt he care... and just incase anyone forgets to use raw string formatting when using python, here is what happens

>>> table = "C:\GISDATA\resultTable"
>>> print(table)
esultTable

No wonder the table couldn't be found