Data in grid cannot be modified. The only way to modify it is to click on the "Book" to open the "Single Record View" in a new window.
1. Exit out of Toad.
2. Go to C:\Program Files\Quest Software\Toad for Oracle\User Files
(... for version 8.6.1. This User Files folder is located in the application data directory for newer versions of Toad).
3. Rename the Toad.ini file (found in the User Files directory)
4. Restarting Toad and test the issue. This will force Toad to regenerate the ini (settings) file with default values.
Keep in mind that Toad requires that you either run the query with rowID or run the statement EDIT <your_table>; to make the data grid editable. If you just run the query SELECT * FROM <your_table> the data gird in the editor will not be editable.
Sample:
EDIT sample_table;
or
SELECT ROWID, sample_table.* FROM sample_table
or
A third option is to access the data from the schema brower | Table | data grid and edit here.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center