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.
- 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.
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 220.127.116.111. 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.
Thank you in advance,