# SQLite connection read only error for DELETE Query

**URL:** <https://forum.inductiveautomation.com/t/sqlite-connection-read-only-error-for-delete-query/56076>\
**Category:** Ignition\
**Created:** [February 13, 2022, 11:36am UTC](https://forum.inductiveautomation.com/t/sqlite-connection-read-only-error-for-delete-query/56076 "2022-02-13T11:36:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [February 13, 2022, 11:36am UTC](https://forum.inductiveautomation.com/t/sqlite-connection-read-only-error-for-delete-query/56076/1 "2022-02-13T11:36:58Z")

</div>

Hello,

When I try to execute a DELETE SQL query for an SQLite DB connection I get read-only read, while I can INSET and UPDATE with any problem. Is there any setting we have to pass for DELETE Query work?

`Error running query: DELETE FROM users WHERE username = "Brad" Cannot run this function when in read-only mode.`

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [February 14, 2022, 4:29pm UTC](https://forum.inductiveautomation.com/t/sqlite-connection-read-only-error-for-delete-query/56076/2 "2022-02-14T16:29:40Z")

</div>

Change the designer to Read/Write mode - the right most arrow here:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/d/dd86a75ec6b7a32697722aae91840a7f2d396393.png)