Problem with UpdateCursor()

IgorBalotsky1

I am writing a simple script to test the updatecursor() function, and here is the code:

import sys, string, os, time, math, arcgisscripting
from datetime import datetime, date

gp = arcgisscripting.create()
gp.overwriteoutput = 1

testConnection = "Database Connections\\testConn.sde"

testTable = "sdeinstance.sde.UPDATE_TABLE"
layerName = "TEST_LAYER"

print "TEST0"
fc = testConnection + "\\" + testTable, "\"LAYER_NAME\" = '" + layerName + "'"
c4 = gp.updateCursor(fc)
print "TEST1"
r4 = c4.next()

The problem is that I keep getting an IO error that the reference to fc does not exist. I have triple checked the names and everything works fine. Maybe it's something simple; any ideas?

Thanks,
Igor

BradPosthumus

In a cursor, the feature class and where clause need to be defined as separate variables. You currently have them in a single variable separated by a comma, which in fact creates a Python tuple.

Try using this format instead:

fc = testConnection + "\\" + testTable whereClause = "\"LAYER_NAME\" = '" + layerName + "'" c4 = gp.updateCursor(fc, whereClause)