SQL Developer

That's interesting, I have a page with a master grid and detail grid and thought I'd check as this doesn't sound good.

When I navigate to a different master without saving the detail it doesn't ask me to save, is that a setting somewhere?  I can try it if you remind me how to set that up?

I can go to a different master record, create a detail record for it and not save, going back to my original master record the unsaved detail record correct for that master is still there.

When I save both detail records are saved to the correct master, it never asks me to save.

Does the detail grid have a column which is nominated as having a master column and that master column is definitely unique?

Not sure if it makes any difference, I'm using 20.1 and for processing my master grid is set to automatic row processing and the detail is set to PL/SQL

I had some progress since yesterday. Apparently, while the two grids followed a Master Detal structure, it wasn't set up as that. Now it is. The Interactive grid on the right side has the left grid as being the Master Detail, while it also has one of it's keys marked as a Master Column.

Saving it does work as well, but with a quirk. When I add new information into a row, then change it to another row, I still get the "You haven't saved" mesage. When I cancel, it still changes to the row that I just clicked, and if I save, it does save it to the previous row, not the current one. So far so good.

However, the information i saved isn't being shown. I checked the database and the saved information has been stored in the table, but it isn't being shown on the grid. At first I thought it had simply refreshed, and I rather needed to load the page again, but it still doesn't show the data. Kinda curious if this is a glitch or I'm making a mistake when it comes to understanding how these Master Detail Grids are set up.

Just another update, the data is now being shown in accord to the Master Column. Becaus there were a couple of unintuitive primary keys in that query, I mistook one of them. But as usual, there is another problem:

This the sequence of the issue:

1. When first selecting a row in the Master Detal, I can see the data on the Child Grid properly.

2. When then selecting another row in the Master Detail, the data from the currently selected row loads properly in the Child Grid.

3. Now I click again on the row from before in the Master Detail, and the Child Grid is empty.

Considering that the Child Grid depends on the Master Column, I don't think it is an issue regarding the assynchronous loading of that column.

Doing a quick debug also brings me some random results. At times, I get nothing but the foreign key inside the table (with the Grid also being empty) while at times I do get something in the console.log command, but the Grid is empty.