>>>>I have an Oracle table being used as a remote view.Updates/edits show up in the view but when I close the view the changes are lost and don't show up in the Oracle table. Any suggestions?
>>>
>>>Sorry, it's silly but did you check SendUpdates box in View Designer?
>> I went back and checked - the send SQL update box and the Update All command button on the update criteria tab in the view designer are both disabled.
>
>So, updates don't go back to table. To enable it you should select primary key and updatable field list and then check the box.
Probably can't find the obvious - where do you select the updateable field list? I added a new remote view went all through the whole drill. Same thing.
Previous
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