General information
Title:
Updating Remote Views
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only