>>>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement