-
Title
Opening a new Editor window with Updateable result set feature on carries over to new Editor wind -
Description
When I turn ON the Updateable Editor icon in one tab, any new tabs will have this feature turned ON as well. This was not the behavior in prior versions (6.1) and could be dangerous if you are not aware that your results are updateable. Why was this changed?
-
Cause
This change was made in 6.2 based on the request in CR5066. (How to keep the Updateable Query option turned ON for all Code Editors).
-
Resolution
Below is the reasoning behind the change made in version 6.2:
In the previous version, both the Auto-Edit mode and the preference to open queries in Updateable mode were removed for security reasons in order to avoid changes made to the data inadvertently. On the other hand, SQL Navigator now has color coding for modified rows and user has to commit modifications for them to take effect. Therefore, to keep the Updateable mode ON can be safe in the current version.According to this, the change was made in the new version to ensure it is easier to tell if the data grid is updateable and to keep the risks minimal.