Even with the updateable option set ON, the plus and minus buttons (+ -) on the data grid are grayed out when there is a comment line in between the SELECT and FROM clause of a query.
See Additional information for examples of queries where the buttons DO work and DO NOT work.
WORKAROUND:
* Do not use comments at all.
* Place comments any place after the end of the FROM clause.
(See Additional Information section for details).
Fixed in the latest version of SQL Navigator. The latest version of SQL Navigator can be downloaded at:
--Examples that buttons works correctly:
select a.firstname, a.lastname, a. ssn
from customer a
where a.lastname = 'String';
select a.firstname, a.lastname, a. ssn
from customer a -- comment here
where a.lastname = 'String';
select a.firstname, a.lastname, a. ssn
from customer a
where a.lastname = 'String'; -- comment here
--Examples with same code that DO NOT work correctly:
select a.firstname, a.lastname, -- comment here
a. ssn
from customer a
where a.lastname = 'String';
select a.firstname, a.lastname, a. ssn
-- comment here
from customer a
where a.lastname = 'String';
