How to update view resp. table
Hello guys! As a newbie to Oracle and Apex I have a question regarding one of my forms.
I have 2 regions with several items. A couple of them are based on a view (based on several joined tables) and don't need to be altered.
Some other items are directly queried via SQL. Those ones can be changed using LOVs. The problem is that I can't update the values of these fields when pressing the submit button. Prior to that, the 2 regions and all respective items relied on a single view (based on one table) and were easily updatable using my submit button and a DML Procedure. Thus I don't know what I am doing wrong. I simply altered the Procedure to take recourse to the item storing the primary-key value.
I know my description is quite vague but maybe you have a clue how to design the form differently. Is there a way to carry out an update statement when pressing the submit button and simply updating the dataset with the values stored in my items? I'd be happy if you could give me a link to a manual so I can walk through that stuff again. Any hint is appreciated.
Thanks guys! You're great!
Sebastian