Thanks, I changed the Updatename list and that appears to have solved the problem.
TEXT TO this.UpdateNameList NOSHOW
ORDER_ID Orders."ORDER ID", CUSTOMER_ID Orders."CUSTOMER ID", EMPLOYEE_ID Orders."EMPLOYEE ID", SHIP_NAME Orders."SHIP NAME"
, SHIP_ADDRESS Orders."SHIP ADDRESS", SHIP_CITY Orders."SHIP CITY", SHIP_REGION Orders."SHIP REGION"
, SHIP_POSTAL_CODE Orders."SHIP POSTAL CODE", SHIP_COUNTRY Orders."SHIP COUNTRY", SHIP_VIA Orders."SHIP VIA"
, ORDER_DATE Orders."ORDER DATE", REQUIRED_DATE Orders."REQUIRED DATE", SHIPPED_DATE Orders."SHIPPED DATE"
ENDTEXT
>>I think I know what the problem is for this error.
>>
>>The CA is sending: UPDATE Orders SET SHIP_NAME=?cursor1.ship_name WHERE ORDER_ID=?OLDVAL('order_id','cursor1')
>>
>>The problem is SHIP_NAME does not exist in the source DB, it is "Ship Name", VFP add the _ to fill in the blank.
>>
>>Is there a way to fix this? I need the update statement to look like this:
>>UPDATE Orders SET "SHIP NAME"=?cursor1.ship_name WHERE ORDER_ID=?OLDVAL('order_id','cursor1')
>>
>
>You might try to fix the updatecmd yourself in the .BeforeUpdate() Method
>You might try fiddling with UpdateFieldList or defining fixed statements.
>
>HTH
>
>thomas