SQLite connection read only error for DELETE Query

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.

Change the designer to Read/Write mode - the right most arrow here:
image

2 Likes