Check the WhereType property. See if setting it to 1 will help. I also have a free CABuilder and CA example code on my web site. For the builder, I have much documentation in the form of comments near the top of the CABuilder PRG file. Just click the FoxPro Tools link at http://www.mctweedle.com

FWIW, I will be providing a new CABuilder when VFP9 ships.

>Yes I set that property and I also tried with other settings.
>The only way to have my Table updated is to select all fields as Key
>but it doesn't seem a good way to use Cursor Adapter.
>
>>Hi Alessio.
>>
>>>I'm having problem using CA. When I modify records in a CursorAdapter I cannot update the main table.
>>>I built CA with the Builder. Set the table optimistic buffer, the datasource is A Native VFP tables which belongs to a Dbc but data don't update.
>>
>>Did you set the update properties on the Auto-Update page of the CursorAdapter Builder? If you don't set those properties correctly, the table won't be updated.
>>
>>Doug