copy joined field

Discussion created by jadams on Feb 13, 2011
Latest reply on Feb 14, 2011 by jadams
I'm trying to copy a field from a joined table to feature class.  This is easily accomplished in ArcMap with the field calculator or in model builder.  However, I can't seem to get it working with Python.  Any help would be greatly appreciated.  Thanks.

arcpy.MakeFeatureLayer_management(sde_SDE_nuts0, sde_nuts0_view)

    # Process: Join Summary Table to NUTS Poly
    arcpy.AddJoin_management(sde_nuts0_view, "NUTS", "sde_SDE_EU_CTY_SUM_view", "Country_Code_NUTS", "KEEP_COMMON")

    # Process: Copy PotPUMTotal - PotPUMTotal field already exists
    arcpy.CalculateField_management(sde_SDE_nuts0, "PotPUMTotal", "[sde.SDE.EU_CTY_SUM_JSA_Test.SUM_PotPUMTotal]", "VB", "")

It errors with Error #999999?