>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...
Erik Moore
Clientelligence