# \[BUG\] Database Query Browser evaporates your edit changes if not in read/write mode

**URL:** <https://forum.inductiveautomation.com/t/bug-database-query-browser-evaporates-your-edit-changes-if-not-in-read-write-mode/78708>\
**Category:** Ignition\
**Created:** [September 4, 2023, 6:26am UTC](https://forum.inductiveautomation.com/t/bug-database-query-browser-evaporates-your-edit-changes-if-not-in-read-write-mode/78708 "2023-09-04T06:26:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [September 4, 2023, 6:26am UTC](https://forum.inductiveautomation.com/t/bug-database-query-browser-evaporates-your-edit-changes-if-not-in-read-write-mode/78708/1 "2023-09-04T06:26:08Z")

</div>

If you've made changes to a table's cell values within this tool and press OK to accept the changes but you don't have the designer in read/write mode, an error tells you that your changes can't be made due to the wrong mode, _ **and your edits subsequently get discarded!** _ Very frustrating, especially if you've made a lot of changes. It should go back into edit mode and keep the edits ready to accept after you've changed the mode, or otherwise, actively discard by Cancel

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [September 4, 2023, 6:56am UTC](https://forum.inductiveautomation.com/t/bug-database-query-browser-evaporates-your-edit-changes-if-not-in-read-write-mode/78708/2 "2023-09-04T06:56:05Z")

</div>

What do you mean, edits get discarded ?  
The query should still be there so you can just rerun it, or am I missing something ?

edit: Oh, you mean in the edit mode !  
Never even noticed those

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [September 4, 2023, 6:57am UTC](https://forum.inductiveautomation.com/t/bug-database-query-browser-evaporates-your-edit-changes-if-not-in-read-write-mode/78708/3 "2023-09-04T06:57:17Z")

</div>

I'm not talking about using INSERT/UPDATE statements, i'm talking about editing cells from a SELECT query from the resultset table itself.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/0/c087febc6deff0a3e8a259b949af9c730c4b33ea.png)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [September 5, 2023, 12:24pm UTC](https://forum.inductiveautomation.com/t/bug-database-query-browser-evaporates-your-edit-changes-if-not-in-read-write-mode/78708/4 "2023-09-05T12:24:45Z")

</div>

I would think a better option would be to disallow selecting Edit mode when in Read-Only comms.

EDIT: OTOH, I barely use it after I started using Datagrip.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 5, 2023, 12:27pm UTC](https://forum.inductiveautomation.com/t/bug-database-query-browser-evaporates-your-edit-changes-if-not-in-read-write-mode/78708/5 "2023-09-05T12:27:55Z")

</div>

> [@JordanCClark](#):
>
> I started using Datagrip.

Datagrip FTW!!