>>Hi All
>>
>>I am trying to update an Oracle table using a remote view. I have set the update criteria in the view designer to update using SQL Update and SQL Where clause includes Key and Updateable fields.
>
>Try just Key fields.
>
>>If I open the view from the command window and move off a record in my view that I have changed I get an error "Update Conflict" and my only options are ok and revert.
>
>Open the view and use Table buffering instead of row buffering. That way, you have a little omre control over when he updates are sent.
>
>>If I change the record and go to the command window with out moving off the record and issue a tableupdate(1,.T.) it deletes the record in my view. Then if I do a requery() the original data comes back.
>
>I am not sure what is going on, but hopefully I can help you find out. When you issue TABLEUPDATE(), check the results. It sounds like they are returning .F.. After a TABLEUPDATE() returns .F., you can check the contents of AERROR() to see the reason for the failure. That should tell you something...

Changed to just key fields. changed to table buffering. Now I can change the record with out it giving me an error. I issue the tableupdate() and it deletes the record from my view. Tableupdate() returns true. Requery() show the data before I changed it.

Thanks for your help but I think that I am going to call it a day. I will work on this more tomorrow.