Well, I tried with aerrors() and what I saw is that I cannot update fields unless they have been marked as Key fields.
But is it right ? I mean is it necessary to mark them as key ? As I red that key fields are treated like primary keys i thought that they could get resources from the system in term of time.
How do you set the CA properties ?
Thank you again
Alessio
>I'll have to try again because I chenged the settings so many times that i can't remember. The only thing I remember is that iwas not satisfied by the CA behaviour.
>I'll let you know tomorrow as is a little bit late here to be at work!!
>:-))
>Thank you All
>
>>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