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.
I'm writing update code to compensate; what a pain.
Larry
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
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'
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?
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.
Does rt-click -> Reset columns help?
Good afternoon John,
Thank you! Sorry, Right click->Reset Columns did not help; but that is nice to know that it is available.
Larry
Possible workarounds (I don't know which will work and which won't)
Can you email me your user files folder and create table script?
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):
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?
Good afternoon John,
Thank you!
Interesting. ok, please email me the "create table" script. I don't need your data, just the table definition. john.dorlon@quest.com. No need to send your user files folder at this point.
Good afternoon John,
I was wrong, this same bug exists in TOAD 14.0; it did work some time back.
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
