Also and check if your TABLEUPDATE() command returns .T., like:
nResult = TABLEUPDATE(< your parameters here >)
>Kengwen,
>Are your tables buffered? You should have only the view buffered. Then when you run the TableUpdate() on the view the changes in the table are automatically saved to the server. If you have buffering on the tables you must run TableUpdate() on them too. Try adding a TableUpdate() to each table AFTER the view TableUpdate() and see if it works.
>
>HTH
>Barbara
>
>>Dear Nick,Barbara,Ed Rauh,
>> Why the parent table didn't updated?
>> Why after i issue the tableupdate() but the table still not update.
>>I am trying to append new record into view.I browse the view and can see that is record added, but i browse the table, i found that it is still no change.
>> Is it i have to set anything before issue tableupdate()? like buffering ?
>>Is it Tableupdate() issue after append the record into view ?
>> I did set view update criteria for every field can be update. Is it have to set DBSetProp() to updateable? or let it be default ?
>>thanks
>>
>>
>>kengwen
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison