Return
-
Title
Unable to edit data in the Data Grid of the Schema Browser | Data Tab. The +, - and post, etc. da -
Description
Unable to edit data in the Data Grid of the Schema Browser | Data Tab. In the data grid, the options +, - ... COMMIT; etc are not enabled/grayed out.
-
Resolution
Enable "Use read-only queries" in View | Options | Data Grid | Data.
A new schema browser may need to be opened for this to be applied.
-
Additional Information
Enabling the option to "Show ROWID in editable grids" will also enable the edit icons in the grid in schema browser, but enabling this will also affect the data grid in the editor. By default, just running a query in the editor will not enable editing through the data grid with the results. This option will automatically include ROWID in the results or the query which will enable editing in the data grid in the Editor.