Toad World® Forums

Aliases Pop up window


#1

When you type in SELECT TM.YOUR_FIELD_NAME (Aliases of the table name) after you type in the period the pop up should display and present a listing of all of the available fields you have in the table. This seems to work and not work. Some times the pop up comes up and sometimes it does not.

When it does pop up, and you start typing it should start to narrow down your choices. This does not work at all. Clicking on the refresh icon does not help either. You can take your mouse and double click on the field you want and that does bring in the field.


#2

I see this. A recent change for another issue broke it.

On 06/17/2014 10:37 AM, armand c wrote:

Aliases Pop up window

Thread created by armand c
When you type in SELECT TM.YOUR_FIELD_NAME (Aliases of the table name) after you type in the period the pop up should display and present a listing of all of the available fields you have in the table. This seems
to work and not work. Some times the pop up comes up and sometimes it does not.

When it does pop up, and you start typing it should start to narrow down your choices. This does not work at all. Clicking on the refresh icon does not help either. You can take your mouse and double click on the field you want and that does bring in
the field.

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.


#3

Just as a follow up to this thread. I wanted to have the word select to automatically change to upper case. SELECT. I went to Options, Editor/Behavior and clicked on the Auto replace button. I put my select in for the value and type in SELECT in the Replace With box. Applied and hit the OK button.

Since I did that when I type in an alias for the table name, the pop up comes up and I start to type, it now filters my list to zero in on my field name!

Hope this helps you folks out. It is a weird one.


#4

I have this fixed for 12.6.0.7 when we build it. I just missed the cutoff for a recent build we did.

On 06/17/2014 01:32 PM, armand c wrote:

RE: Aliases Pop up window

Reply by armand c
Just as a follow up to this thread. I wanted to have the word select to automatically change to upper case. SELECT. I went to Options, Editor/Behavior and clicked on the Auto replace button. I put my select in for the value and type in SELECT in the
Replace With box. Applied and hit the OK button.

Since I did that when I type in an alias for the table name, the pop up comes up and I start to type, it now filters my list to zero in on my field name!

Hope this helps you folks out. It is a weird one.

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.


#5

Well the new release of 12.6.0.35 has broken this again. Sometimes it works, sometimes it does not. Then it seems to loose its mind by displaying in the upper right hand corner. When it feels better, it displays normally then does not work at all.


#6

Are you referring to the code insight popup? Is it purely positioning problems you’re experiencing? I made some recent changes to position it where it will fit if there’s not enough room below the current line. Are you running multiple monitors? If so, what
is the layout of them (side by side, etc.) and is Toad on your primary monitor? Can you provide a screenshot that shows your caret position and where the popup displays?

Thanks,

Michael

On 08/11/2014 12:36 PM, armand c wrote:

RE: Aliases Pop up window

Reply by armand c
Well the new release of 12.6.0.35 has broken this again. Sometimes it works, sometimes it does not. Then it seems to loose its mind by displaying in the upper right hand corner. When it feels better, it displays normally then does not work at all.

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.


#7

I use 2 monitors. If Toad is on monitor 1, the pick-list pops up correctly. When Toad is on monitor 2, pick-list pops up on monitor 1, on the right-hand side - not very convenient. Just tried this with .40 and it’s still happening.


#8

Ok. Thanks.

On 08/15/2014 01:02 PM, droeschley_109 wrote:

RE: Aliases Pop up window

Reply by droeschley_109
I use 2 monitors. If Toad is on monitor 1, the pick-list pops up correctly. When Toad is on monitor 2, pick-list pops up on monitor 1, on the right-hand side - not very convenient. Just tried this with .40 and it’s still happening.

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.


#9

Hi,

When I create a join query with table alias and if stopped after table alias, a pop up appears with blank values and Pop up generally don’t go after that. It’ll not allow me to do anything in toad during that time. some time it went in Not responding state for hours and hours. I need to kill the toad from task manager to disappear this issue.

I am using 12.6.0.53 version.

Please advise if you have any solution. Sorry, if i hacked someone else tread.

Thanks,

Amit


#10

Exmaple:

Select Col1, Col2 from tab t1 join tab2 t2 on t1.

Then pop up will come and don’t go.