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')





>Thanks that fixed that error. Now I get a different error.
>1435 - "Microsoft SQL Server Compact OLE DB Provider : The given type name was unrecognized. [,,,,,]"
>
>Any ideas on that one?
>
>

>
>    This.DataSource = this.oRS
>    this.oCommand = CREATEOBJECT("ADODB.COMMAND")
>    This.UpdateCmdDataSource = this.oCommand
>    This.oRS.ActiveConnection = this.oConn
>    this.oCommand.ActiveConnection = this.oConn
>
>

>
>>
>>
>>

>>Check UpdateCmdDataSource in help:
>>
>>"ADO"  UpdateCmdDataSource must be set to a valid ADO Command object.
>>       The ActiveConnection property of the ADO Command object must be set to a valid and open ADO Connection object.
>>
>>       Visual FoxPro sets the CommandText property of the ADO Command object to the value of the CursorAdapter UpdateCmd property.
>>       Visual FoxPro parses the command for  parameters, creates parameter values if found, and sets them in the Command object.
>>
>>       The update operation occurs as:
>>       CursorAdapter.UpdateCmdDataSource.Execute()
>>
>>      For more information about using an ADO RecordSet, automatic updating, and generating SQL commands automatically, see Data Access Management Using CursorAdapters
>>