Oracle APEX 24.1.6 | Oracle DB 19c
Hi, so I was running into this issue (when clicking “Save” on IG I don't see newly added row). I think it is because the “Save Interactive Grid Data” process has “Return Primary Key(s) after Insert” set to False / Disabled, which in turn is set that way because the RETURNING clause doesn't work for this particular table… it's a synonym to a table on a remote server.
So… I then tried a DA that refreshed the IG. But, that resulted in this issue: Cannot read properties of null (reading '0'). Here is another post I found describing the same thing, it appears. So the problem seems to be that now the IG is refreshing too soon, whereas before it was refreshing too late…
So, I then tried an action in my DA that executes JavaScript. I am running the code location.reload(); which I found here. This seems to work, despite a significant delay in the page reloading (a second or two).
This is acceptable to me, but I was wondering if anyone has thoughts or suggestions on how to improve. Note that I did try delaying the IG refresh for 250-500 milliseconds, but I still got the null error.
Thanks, Jared