Recent content by Fabian Röling

I need to specify "rowid" anyway, is that not enough?

Since there seems to be no "meta" category of the forum, I'm posting this here. I'm not a legal expert, but this part of the "Terms and rules" that I'm forced to accept when registering for an account here (https://forums.allroundautomations.com/help/terms/) seems weird: "These terms may be...

After executing this query... select a.*, a.rowid from table_b b, table_a a where a.x=b.x; ...very unintuitively, I can click the "Edit data" lock icon and get no error message, but I cannot actually change anything in the results view, all keypresses are silently discarded. This, however...

With "right click on the table", do you mean on the word in the query? That option seems to be removed or renamed since then. Maybe it's "Table [name]"->"Browse", but I get an error when I click that. Here is a related discussion, but it's quite chaotic...