uhm, ok thanks . I'm going to check it tomorrow.
Anyway I have those settings
Properties :
Use DataEnvironment DataSource = .t.
DataSourceType = Native

Data Acces :
select command = Mytable.*
BufferModeOverride = Optimistic row buffering

Auto Update
Send updates = .t.
Auto Update = .f.
Update using SQL update

I also tried with send update = .t. and auto update = .t.
checking all of the fields but the only way to have my Table updated is to check all of the fields as key.



>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