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.

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.

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.

What am I missing here?

Thanks in advance for your help.

Jeff Whitaker