Hi allI tried to run this calculate field in a model, python and vb.net and I shows everywhere the same error message below.Please advise.Executing: CalculateField ServicePointTable_View XXXX.ServicePointTable.SPCWASDID str(!XXXX.PremisePoints.SPCWASDID!) PYTHON # ServicePointTable_ViewStart Time: Wed Aug 31 13:08:50 2011ERROR 999999: Error executing function.An invalid SQL statement was used.An invalid SQL statement was used.An invalid SQL statement was used.Failed to execute (CalculateField).End Time: Wed Aug 31 13:08:50 2011 (Elapsed Time: 0.00 seconds)Python Code:# Process: Calculate Field...gp.CalculateField_management(ServicePointTable_View, "XXXX.ServicePointTable.SPCWASDID", "[XXXX.PremisePoints.SPCWASDID]", "PYTHON", "")VB.net Code pCalculateField.in_table = "ServicePointTable_View"
pCalculateField.field = "XXXX.ServicePointTable.SPCWASDID"
pCalculateField.expression = "!XXXX.PremisePoints.SPCWASDID!"
pCalculateField.expression_type = "PYTHON"
RunTool(GP, pCalculateField, Nothing)