Oracle APEX 24.1 | Oracle DB 19c
Hi, I am trying to implement John Snyder's “auto save” feature for interactive grids from his IG Cookbook v6. John says “see the code added in page attribute ‘Function and Global Variable Declaration’ and the 2 dynamic actions”. I specifically want to implement the ‘Check After Row’ auto save. I've tried a few different things so far:
- I copy / pasted everything from the ‘Function and Global Variable Declaration’ into the same for my page. Then I put
app.startRowSave('ig_static_id'); into both ‘Execute when Page Loads’ and a DA that executes on Page Load
- Since I don't have ‘P38_SAVE_OPTIONS’, and the value for ‘Check After Row’ is ‘R’, I tried removing inapplicable code, and trying again. I went through different iterations of this
- I tried keeping everything, adding a page item ‘P38_SAVE_OPTIONS’, settings its default value to ‘R’, still no luck…
Note that I am also adding the dynamic actions for the “Save [Interactive Grid]” event as well as the On Page Load DA…
In my case, I can't get my IG to auto save, at least not in the fluid manner of the cookbook example. What happens is I'll add an item, it'll have a slightly green background (to indicate it's client-side only) and then if I click out of it, nothing happens. If I then click Add Row, it seems to save, but then I am unable to click on my Popup LOV. If I take out all this code, I have no such issues.
I'd appreciate any ideas on what might be causing the issue. Happy to share more of my setup / specifics - I can even try to create a duplicate on apex.oracle.com.