Add new row to empty file geodatabase table

ClaudineSicker

I am using ArcGIS 10.1 and have created a script that checks to see if a file geodatabase table is empty. It is a table with no spatial referencing.

The code I have thus far can add rows to tables that already have a record in it, but it will not add a new row to an empty table.

Can this be done? Would it be better accomplished if it were a dbf file rather than a geodatabase table?

Snippet of code looks like this:

    addRow =arcpy.da.InsertCursor(Variable1,("Frequency", "Used", "Region"))
    result = arcpy.GetCount_management(Variable1)
    print result
    print addRow
    if result == 0:
    [indent]addRow.insertRow((0, "Locally", 3))[/indent] 
    else:
    [indent]do something else[/indent]

result and addRow printouts are correct. Prior tests taking out the if, else statements and just running the addRow.insertRow statement showed that tables that have at least one record get appended with a new row.

So I am of the opinion that I cannot add a new row using this approach. Any other ideas as to how I can add a row to an empty table.

Many thanks.

MathewCoyle

Result is not an integer you can compare how you are. You need this.

result = int(arcpy.GetCount_management(Variable1).getOutput(0))

Also don't forget to add this at the end of your script.

del addRow