Only last statement in SQL editor executes

[Grismar]

Details

If you write a query consisting of multiple statements, only the last statement appears to execute, even though the entire query is parsed without error (and errors are caught in prior statements)

Steps to reproduce

Write a two line query, i.e.:

insert into data values(0);
insert into data values(1);

Run the query, note that only one row is affected and only the last line has an apparent effect on the table.

Operating system

Windows 10 Pro 64-bit.

SQLiteStudio version

v3.2.1

[pawelsalawa]

By default SQLiteStudio executes only the query that is under the insertion cursor (or closest to it). I'm guessing you have your insertion cursor at the very end of SQL editor contents and thus the last query gets executed.

You can either select (with mouse, or shift+arrows or ctrl+a) queries you want to execute, or you can change setting in the Configuration Dialog to execute all queries in the editor by default, instead of the one under the cursor.

[Grismar]

Thanks for getting back to me - this was indeed the issue. To me, the default is counter-intuitive to me - obviously, hence the question, but apologies for not finding this in the documentation myself. I changed it as you suggested, but I do appreciate how it might be useful and I like that it is configurable.

Although perfection doesn't exist, given that this seems like a non-obvious feature (it clearly is that), perhaps it would be good to provide a non-intrusive hint on-screen that this is happening and can be configured? (one that can be dismissed forever after first showing it, ideally?) Or, alternatively, perhaps have a toggle button on the SQL editor to quickly switch between execute selected line / execute all lines would be a great added feature? (I would have found it, as I did look around for an "execute all button", I just didn't take the step of looking at configuration)

[pawelsalawa]

Created #4312 for this.

[Grismar]

(by the way, love your project, just made a long overdue donation - please keep it up, impressive!)