Toad World® Forums

Pop Up List

I have found where the pop up does not work. Example: SELECT * FROM SCHEMA.TABLENAME TB WHERE TB. the pop up does come up here.

If you type only this in your editor: INNER JOIN TABLENAME TB WHERE TB. The pop up comes up but no data is shown for any field choices. Hitting the refresh icon does not help either.

Now, I suppose if someone is just typing INNER JOIN TABLENAME TB WHERE TB. in a blank editor and actually expects the query to work, they first should consult with someone who can construct a query.

So, this just might be “working as intended”.

In the past Toad would scan for your table references using a best guess technique. This worked in most cases. Toad is now using the parser to accurately detect the table name in all cases; however, the statement has to be complete enough to be able to locate
the table name. Your inner join sample works in 12.1 using the best guess, but is not close enough to a complete statement for the parser to make sense of it as of 12.5.

Michael

On 06/18/2014 05:45 PM, armand c wrote:

Pop Up List

Thread created by armand c
I have found where the pop up does not work. Example: SELECT * FROM SCHEMA.TABLENAME TB WHERE TB. the pop up does come up here.

If you type only this in your editor: INNER JOIN TABLENAME TB WHERE TB. The pop up comes up but no data is shown for any field choices. Hitting the refresh icon does not help either.

Now, I suppose if someone is just typing INNER JOIN TABLENAME TB WHERE TB. in a blank editor and actually expects the query to work, they first should consult with someone who can construct a query.

So, this just might be “working as intended”.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.