Sometimes (not always) when I'm going to edit data in a table and the table is opened using "Edit Data" <CTRL+E>", the editor switches selected data set from Updatable to Read-Only after I modify the select statement in the editor. Clicking on the editor's buttons "Updatable", then "Execute to End (F9)", does not fix the problem - the data set is still Read-Only.
WORKAROUND:
Add rowid as one of the columns being returned in the SELECT statement.
Example - Select rowid, col1, col2 from tablename;
STATUS:
Waiting for fix to be released in a future version of SQL Navigator.
Issue has been fixed in the 6.3 beta version.
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center