>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