AnsweredAssumed Answered

Field calc across join to table view

Question asked by KevinBellSLC on Aug 23, 2013
Latest reply on Aug 26, 2013 by rfairhur24
Why doesn't this work?!  I'm going nuts!

    addrTbl = r'Database Connections\Connection to blah.sde\blah.dbo.addr'
    parcelTbl = r'Database Connections\Connection to blah.sde\blah.dbo.parcel'
    arcpy.MakeTableView_management(parcelTbl, 'parcelTv')
    arcpy.MakeFeatureLayer_management('default.gdb\\bm_parcels_calc', 'calcLyr')
    arcpy.AddJoin_management('calcLyr', "PARCEL_PIN", 'parcelTv',"parcel_id","KEEP_ALL")
    # works to here.
    arcpy.CalculateField_management('calcLyr',"PARCEL_KEY", 'parcelTv.parcel_key')

Show me how to fix it and I'll buy you lunch at next years UC!