How are you doing the update? Tableupdate()? Are you getting an error message? What does the following return after issuing a Tableupdate(0, .t.) command?

? aerror(laErrors)

If greater than 0, type the command:

list memo like laErr*

Are you providing a unique PK value to your key field?

>Hi Mark
>yes .
>All that has been done including checking the send sql updates check box.
>I have also selected the Primary key and the updateable fields .
>
>What do do now ?
>
>>I repeat the question I asked before:
>>
>>On the UPDATE CRITERIA of the View Designer, have you checked the box to Send Updates, and have you identified [placed a check mark next to] the key and updatable fields?
>>
>>>Hi
>>>Yes u are right about buffering but i the data in the columns is not being put !
>>>After an append blank the data remains blank even after i change it.
>>>
>>>Any idea y ?
>>>
>>>>>Hello People
>>>>>
>>>>>I have a question.
>>>>>
>>>>>I have a updateable view as follows.
>>>>>
>>>>>Select People.Name, as PartyName , People.Code as PartyCode from People
>>>>>
>>>>>I have made it updateable in the view designer.
>>>>>
>>>>>In the view,
>>>>>I use append blank to add a record to it and set fields to some New values.
>>>>>
>>>>>But the problem is the base table People is not getting updated.
>>>>>
>>>>>WHat am i doing wrong ?
>>>>
>>>>In the View Designer, you checked the box to Send Updates, and you identifeid the key and updatable fields? After you append the record and add data, you then either have to move the record pointer to another record in order to fire off an implicit TableUpdate() [if your view is record buffered], or you have to issue the TableUpdate() function. See VFP help on that function.
>>>>
>>>>I also recommend using table buffering instead of record buffering. See CursorGetProp() and CursorSetProp() in VFP help.