# Lost ability to edit in latest beta **URL:** \ **Category:** Toad for Oracle - Beta\ **Created:** [March 19, 2021, 6:43pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432 "2021-03-19T18:43:01Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![wickliffe.larry](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/wickliffe.larry/32/228_2.png) [@wickliffe.larry](https://forums.toadworld.com/u/wickliffe.larry)\ **Post date:** [March 19, 2021, 6:43pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/1 "2021-03-19T18:43:01Z")
Good afternoon TOAD team, This happened a while back with an older version of TOAD, I am connected as schema owner, have Read Only unchecked, ROWID is in the table list and the list is default, I cannot edit values. Sorry to throw this on you at the 11th hour 59th minute on TOAD 14.1 deployment. ![image](https://global.discourse-cdn.com/quest/original/2X/7/736920a9b1dd0f3a2b3c7ca0abd60a415b71612b.png) I'm writing update code to compensate; what a pain. Larry ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 19, 2021, 6:50pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/2 "2021-03-19T18:50:21Z")
Hi Larry, I can still edit in SB-Tables-Data. I see you have a filter/sort applied. Please click the "view/edit" sql button next to that so I can see the SQL. Thanks -John ---
**Author:** ![wickliffe.larry](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/wickliffe.larry/32/228_2.png) [@wickliffe.larry](https://forums.toadworld.com/u/wickliffe.larry)\ **Post date:** [March 19, 2021, 7:11pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/3 "2021-03-19T19:11:20Z")
Good afternoon John, Here is the SQL: SELECT ROWID, RCIP\_NO, SEQ\_NO, W2W\_PASSWORD, W2W\_PIN, CONT\_NAME, ADDR1, ADDR2, CITY, STATE, ZIP, CONT\_PHONE, CONT\_FAX, CONT\_EMAIL, PROG\_CODE, INST\_TYPE, DATE\_LAST, DATE\_NOTIFIED, DATA\_ADDED\_BY, NOTIFICATION\_SENT\_BY, PRIM\_CONTACT, RCIP\_NAME, CONT\_TITLE, RCIP\_TYPE, USER\_ID, USER\_STATUS\_ID, USER\_LOGIN\_TRIES, USER\_NAME, USER\_DATE\_LOCKED, USER\_NAME\_SEQUENCE, USER\_FORGOT\_PW\_RESET\_UUID, USER\_FORGOT\_PW\_RESET\_DATE, USER\_PW\_EXPIRATION, USER\_PASSWORD, GK\_NO, UUID FROM COMMON.WHO\_ARE\_YOU WHERE SEQ\_NO = 1 -- AND lower(CONT\_EMAIL) LIKE '%wickliffe%' --AND lower(CONT\_EMAIL)= 'wickliffe.larry@dol.gov' ![image001.png](https://global.discourse-cdn.com/quest/original/2X/7/7973a5292dcf4ec514a01bb165f24a99b478ca0a.png) ![image001.png](https://global.discourse-cdn.com/quest/original/2X/9/9729f9ba534263909a4d63fa9212212ffc8b5afd.png) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 19, 2021, 7:18pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/4 "2021-03-19T19:18:48Z")
Hi Larry, I'm not sure why it's not working. I tried similar edits here and there was no problem. Does the cell not go into edit mode if you start typing? or does it seem to take the edit but then it doesn't? Also, does the problem happen with every table? What about in another DB? Or if you go into editor and try the query there? ---
**Author:** ![wickliffe.larry](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/wickliffe.larry/32/228_2.png) [@wickliffe.larry](https://forums.toadworld.com/u/wickliffe.larry)\ **Post date:** [March 19, 2021, 7:45pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/5 "2021-03-19T19:45:05Z")
Good afternoon John, Table specific, I can edit data in other tables in the same schema, as I usually can. It appears that I can edit the data but typing and paste fail: I can move in the fields, just delete, backspace and characters do nothing. ![image001.png](https://global.discourse-cdn.com/quest/original/2X/c/cab3bdc6fca6486c14fc5350c7a538e668a5bef1.png) ![image001.png](https://global.discourse-cdn.com/quest/original/2X/9/9729f9ba534263909a4d63fa9212212ffc8b5afd.png) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 19, 2021, 8:10pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/6 "2021-03-19T20:10:05Z")
Does rt-click -\> Reset columns help? ---
**Author:** ![wickliffe.larry](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/wickliffe.larry/32/228_2.png) [@wickliffe.larry](https://forums.toadworld.com/u/wickliffe.larry)\ **Post date:** [March 19, 2021, 8:14pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/7 "2021-03-19T20:14:51Z")
Good afternoon John, Thank you! Sorry, Right click-\>Reset Columns did not help; but that is nice to know that it is available. Larry ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 19, 2021, 8:25pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/8 "2021-03-19T20:25:20Z")
Possible workarounds (I don't know which will work and which won't) 1. Double-click the cell in Schema Browser to use popup editor 2. right-click the grid and choose "Single Record View" 3. in Editor, type in EDIT COMMON.WHO\_ARE\_YOU in the editor, then run with F9, edit there instead 4. Use version 14.0 Can you email me your user files folder and create table script? ---
**Author:** ![wickliffe.larry](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/wickliffe.larry/32/228_2.png) [@wickliffe.larry](https://forums.toadworld.com/u/wickliffe.larry)\ **Post date:** [March 19, 2021, 8:49pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/9 "2021-03-19T20:49:22Z")
> [@JohnDorlon](#): > > EDIT COMMON.WHO\_ARE\_YOU Thank you John, How do you get a filter in the editor? All fail except EDIT ... in the editor, screen shot of success below and the last works, too (v14.0): ![image](https://global.discourse-cdn.com/quest/original/2X/4/41e01dc2b8bdbe4a47f16e9f22f3e9374e6b1b27.png) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 19, 2021, 8:52pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/10 "2021-03-19T20:52:37Z")
you can say 'edit tablename where....' but you have to put the where clause all on one line. How about if you just paste that entire SQL that you showed me into the editor? ---
**Author:** ![wickliffe.larry](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/wickliffe.larry/32/228_2.png) [@wickliffe.larry](https://forums.toadworld.com/u/wickliffe.larry)\ **Post date:** [March 19, 2021, 9:30pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/11 "2021-03-19T21:30:14Z")
Good afternoon John, Thank you! 1. Running the entire SQL in the editor, has same error as schema browser: ![image001.png](https://global.discourse-cdn.com/quest/original/2X/9/9729f9ba534263909a4d63fa9212212ffc8b5afd.png) ![image004.png](https://global.discourse-cdn.com/quest/original/2X/9/966e890c111eafb86cc86d81340ca431178f9d2a.png) ![image005.png](https://global.discourse-cdn.com/quest/original/2X/8/8e7816878d3650525dbce07d39ea6a45fb4a54fe.png) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 19, 2021, 9:33pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/12 "2021-03-19T21:33:25Z")
Interesting. ok, please email me the "create table" script. I don't need your data, just the table definition. [john.dorlon@quest.com](mailto:john.dorlon@quest.com). No need to send your user files folder at this point. ---
**Author:** ![wickliffe.larry](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/wickliffe.larry/32/228_2.png) [@wickliffe.larry](https://forums.toadworld.com/u/wickliffe.larry)\ **Post date:** [March 19, 2021, 9:53pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/13 "2021-03-19T21:53:30Z")
Good afternoon John, I was wrong, this same bug exists in TOAD 14.0; it did work some time back. ![image001.png](https://global.discourse-cdn.com/quest/original/2X/9/9729f9ba534263909a4d63fa9212212ffc8b5afd.png) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 22, 2021, 7:28pm UTC](https://forums.toadworld.com/t/lost-ability-to-edit-in-latest-beta/52432/14 "2021-03-22T19:28:59Z")
This is a bug. When there is an '@' anywhere in the SQL text (even a comment), and Options -\> Schema Browser -\> Data Tab -\> "Fetch 25 rows at a time through DB Links" is checked, the query will be read-only. It will be fixed soon. -John