What TABLEUPDATE() returns? .t. or .f.. If it returns .f. You can use AERRORS() to check what cause the problems
>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.