Toad Add / Insert and Delete Entries Button Disabled

Question

I am using Toad 8.6, and when I try to add new entries using the Schema Browser tab, the Data tab, my “insert record” is grayed out. So, I installed version 9.6, and this problem persists.

See the gray buttons, red in the image.

I can add records through the SQL insert statement in the SQL Toad editor.

How can i solve this?

Answer 1

Do you mean the + button that appears at the top of the SQL result table?

There is a “Change Grid” button that you must click first to enable changes to the data grid. Otherwise, the result grid is read-only.

Answer 2

If rowid is selected, then the insert / edit icons will be included. e.g. select rowid, t.* from table t

Answer 3

Uncheck the "By default, read-only" option in the "Tip" option ("View" - "Options" - "Data Grid - Data")

Answer 4

Is your TOAD installed read-only? Help files provide information on installing TOAD as a read-only application.

Answer 5

If you are in the viewer, you need to clear the read-only check box in the far left corner of the viewer. You get to this by pulling out the menu to the right of the red button. After unchecking the button, the button will turn green.

Answer 6

Options> Data> Disable "Use read-only"> click "OK"> "Close Schema Browser" and open a new Schema browser window to see that the buttons are enabled: