Hey Mark,

I don't see anything wrong. Have you tried setting CA.BreakOnError to .t. and then paring down the statement, clause by clause until it stops breaking?

>Using the Northwind sample database in VFP [not MSDE], I have the following in my UpdateCmd property:

>update customers set ;
> COMPANYNAME = ?RTRIM(crsCustomers.COMPANYNAME), ;
> CONTACTNAME = ?RTRIM(crsCustomers.CONTACTNAME), ;
> CONTACTTITLE = ?RTRIM(crsCustomers.CONTACTTITLE), ;
> ADDRESS = ?RTRIM(crsCustomers.ADDRESS), ;
> CITY = ?RTRIM(crsCustomers.CITY), ;
> REGION = ?RTRIM(crsCustomers.REGION), ;
> POSTALCODE = ?RTRIM(crsCustomers.POSTALCODE), ;
> COUNTRY = ?RTRIM(crsCustomers.COUNTRY), ;
> PHONE = ?RTRIM(crsCustomers.PHONE), ;
> FAX = ?RTRIM(crsCustomers.FAX) ;
>where CustomerID = ?crsCustomers.CustomerID

>I modified the formatting above for readability, just remove the semi-colons and CRLFs to get the actual string. AERROR() is returning "Error 10: Syntax error" when the CA uses this for the update of the source table. [llRetVal = TABLEUPDATE(1, .f., 'crsCustomers') returns FALSE.] The cursor crsCustomers does exist and its structure is identical to the source table, Customers, in the Northwind DBC. I also have SET DATABASE TO NORTHWIND in the BeforeOpenTables of the DE. For the life of me, I can not figure out what could be wrong with this UpdateCmd. Any clues appreciated. TIA!