Why this error message: An invalid SQL statement was used

JoseSanchez · ‎08-31-2011

Hi all

I 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_View
Start Time: Wed Aug 31 13:08:50 2011
ERROR 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)