Hello,
I’m relatively new here, and I don’t know there to report bug, so I’m writing it here.
When having in SELECT field with name that contains word “FROM” in it’s name, alias INSIGHT for table is not working…
i.e.:
SELECT C.CONTRACT_ID, C.DATE_FROM
FROM TB0_CONTRACT C
when you try to add condition in WHERE clause using table alias with INSIGHT (code assistant / intellisense / or what is it’s name)
it doesn’t open window with field list.
When comment c.date_from then it works ok.
i.e.:
SELECT C.CONTRACT_ID/, C.DATE_FROM/
FROM TB0_CONTRACT C
Please fix
Thanks in advance
Dino
Have you tried using one of the shortcut key sequences, like or -t to force the list open?
I have just tried it and it doesn't work.
when pressed it shows list of public synonyms, but no tables.
I tried a similar example in 12.5 and it’s working OK. Can you send me your table DDL and Toad.ini offline so I can try your example here? michael.staszewskiquest.com
This is what I see…
Hello Michael,
seems you have misunderstand,
the problem is in using field that contains “FROM” in it’s name.
here is DDL of sample table:
CREATE TABLE TEST_DINO
(
ID VARCHAR2(1 BYTE),
DATA1 VARCHAR2(1 BYTE),
DATA2 VARCHAR2(1 BYTE),
DATE_FROM VARCHAR2(1 BYTE)
)
Create this table, and try to write this query on you own (not copy paste), and I guess you will realize what I’m talking about:
SELECT D.ID,
D.DATA1,
D.DATE_FROM,
D.DATA2
FROM DWH_DEV.TEST_DINO D --USE YOUR SCHEMA
WHERE D.DATA1 = ‘1’
AND D.DATA2 = ‘2’
Thanks
With kind regards
Dino
This is fixed in the current Toad 12.7 release. Using this SQL…
SELECT D.ID,
D.DATA1,
D.DATE_FROM,
D. – Try to invoke Code Insight here
FROM MSTASZEW.TEST_DINO D
WHERE D.DATA1 = ‘1’ AND D.DATA2 = ‘2’
…I do not get assistance in 12.5, but 12.7 correctly shows the popup filtered to TEST_DINO’s columns.
Thanks,
Michael
Thanks Michael,
I wasn’t aware of that (I’m still on 12.6.0.53)
In that light, sorry for disturbance, and thank you for your time.
Have a nice day
With kind regards
Dino
