We’ve noticed some strange behaviour when we try and edit table data by using Ctrl-E from the DB Explorer.
Ctrl-E on the table generates a select statement that returns all the data in the table. At this point all the data is editable and the UPDATEABLE icon is ON.
select *
from table_a
However, as soon as I add a ‘where’ clause to the generated select statement, it’s not possible to edit the table anymore, although the UPDATEABLE icon still shows as ON.
select *
from table_a a
where a.table_id = 123
Turning UPDATEABLE icon OFF and ON again, does not make a difference. We’ve experienced this on a number of pc’s with SQL Nav 6.2.1.1521. What is strange though, is that this behaviour is not consistant for all tables. On some of them, the table is still in edit mode even after I’ve added a ‘where’ clause.
Thanks for reporting this issue. This bug only appears if the query spans more than 2 lines or the where clause is on the same line as the from clause.
select a.col1,
a.col2
from table_a a where a.col1 = 123; --this doesn’t work
A work-around would be to modify the code as follow:
/where clause on the same line as from clause but the query is less than 3 lines long/
select *
from table_a a where a.table_id = 123;
or
/where clause is not on the same line as from clause/
select *
from table_a a
where a.table_id = 123; – this query works for me
Let me know if it works. We will have this fixed soon.