Why is only the first mentioned table updateable in the results view?

[Fabian Röling]

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, works:
select a.*, a.rowid from table_a a, table_b b where a.x=b.x;
The results look exactly the same, but I can type.
Here is a thread about this from 2013: https://forums.allroundautomations....pdated-when-selecting-from-more-tables.12003/
But after the clarification, it never got an answer.

Is it intended that only the first mentioned table is editable? If yes, why? If no, it's a bug that exists at least since 2013, so it would be nice to get a fix.

 

[Marco Kalter]

Typically only one table of a query will bey key-preserved (unless there is a one-to-one relation between the tables), so only one table can be updated. The SQL Window assumes that the first table is the key-preserved table.

 

[Fabian Röling]

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

 

[Marco Kalter]

The SQL Window currently does not resolve the rowid to a table name. I have added this to the list of enhancement requests. In this case there would indeed no longer be a table order requirement for the FROM clause for updateable result sets.