Description: I can change whether a column is autoincremented or not in the jdbcDriverOOo[1] driver. When changing this option, by the drop-down list which depends on the column which is selected, if we validate the changes by the Save button (Ctr + S) while then did not take care to click again in the list of columns then the changes are saved but Base will ask you to save again before closing. If after changing the auto value option, I click in the list of columns (it doesn't matter which one) and I save using the Save button then when I close this window, Base does not ask me anything... Steps to Reproduce: 1. Edit a table in Base. 2. Try to modify the auto value option 3. Save and exit the table editing window 4. When you exit Base asks you to save again. Actual Results: Base asks to save the changes even though it has just been done. Expected Results: Base don't asks to save the changes. Reproducible: Always User Profile Reset: No Additional Info: If just before saving using the Save button you make sure to put the cursor back in the column grid (with a click on one of the columns) then everything will work correctly. [1] https://prrvchr.github.io/jdbcDriverOOo/
Maybe I'm wrong, but I think there are two different saves. The first one is to save the table modification in the database file, then it is applied. The second one is to save Base at exit, Base is a front-end, and has more components than the database, like configurations, forms, reports, queries, etc., not only the database, having in this case their database modified.
Created attachment 193231 [details] Table design mode
Created attachment 193232 [details] Save change message
> The first one is to save the table modification in the database file, then it is applied. > The second one is to save Base at exit, Base is a front-end, and has more components than the database, like configurations, forms, reports, queries, etc., not only the database, having in this case their database modified. No, I'm not talking about the message that Base gives when you exit it, but a message that appears when you exit the design table. See attached screenshot
Considering how I manage to reproduce this problem, it seems that it is linked to where the focus is in the window when clicking on the save button (Ctr + S). And apparently the focus must be moved in the grid for this to work.
Well another problem is that I can't reproduce without the jdbcDriverOOo extension, since I can't find a driver that allows you to change the AutoValue option, save it using the Save button (Ctr + S) then finally exit the table design window in order to display the error message.
After several tests I confirm that if the focus is on the AutoValue combobox and we save using the Save button then there will be the message asking to save when exiting the table design window.