When the TABLEUPDATE() returns .t. is teh new record is inserted in the actual table?
>TableUpdate returns .F. if I modify an existing record and .t. if I insert a new record.
>
>>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.