Toad 12.5 - Code Assist not using table alias!

cstaber · June 10, 2014, 8:29am

If I have something like this:

SELECT
i.
FROM
dss_icsmgt_stage.e_cp_ics_initiative i

When I get to the “i.” and select a column from the menu, rather than it displaying “i.column_name”, it changes to “e_cp_ics_initiative.column_name”. I upgraded from 12.1 and it was working with the aliases before. I tried going through the options menu, but couldn’t seem to find anything.

Any help would be greatly appreciated!

Thanks!

-Chris

mstaszew · June 10, 2014, 8:39am

I don't think it could be option related, but to rule that out please email me your Toad.ini file offline to michael.staszewskiquest.com

I tried with the following SQL and it retained the alias. select i. from scott.emp i

Michael

On 06/10/2014 11:30 AM, cstaber wrote:

Toad 12.5 - Code Assist not using table alias!

Thread created by cstaber
If I have something like this:

SELECT
i.
FROM
dss_icsmgt_stage.e_cp_ics_initiative i

When I get to the "i." and select a column from the menu, rather than it displaying "i.column_name", it changes to "e_cp_ics_initiative.column_name". I upgraded from 12.1 and it was working with the aliases before. I tried going through the options menu, but couldn't seem to find anything.

Any help would be greatly appreciated!

Thanks!

-Chris

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

cstaber · June 10, 2014, 8:43am

Actually, I just closed everything and restarted my computer and now it’s working and using the alias. Weird. I think I’m good now - I’ll keep an eye on it.

Thanks!

-Chris

*** Nevermind, didn’t really fix it

cstaber · June 10, 2014, 8:48am

Actually, I just realized it was only working because I didn’t use a schema name in the FROM. When you use a schema.table_name - it doesn’t pick up the alias. When you just list the table name by itself without the schema prefix, it then picks up the alias. This holds true every time so far. So I guess it’s not quite fixed

mstaszew · June 10, 2014, 8:49am

In my sample SQL the schema name was included.

On 06/10/2014 11:48 AM, cstaber wrote:

RE: Toad 12.5 - Code Assist not using table alias!

Reply by cstaber
Actually, I just realized it was only working because I didn't use a schema name in the FROM. When you use a schema.table_name - it doesn't pick up the alias. When you just list the table name by itself without the schema prefix, it then picks up the alias.
This holds true every time so far. So I guess it's not quite fixed

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

mstaszew · June 10, 2014, 8:52am

Ignore my last comment. You're using the schema name you are logged in as I assume. I see it under this condition as well.

On 06/10/2014 11:50 AM, Michael Staszewski wrote:

Re: Toad 12.5 - Code Assist not using table alias!

Reply by Michael Staszewski
In my sample SQL the schema name was included.

On 06/10/2014 11:48 AM, cstaber wrote:

RE: Toad 12.5 - Code Assist not using table alias!

Reply by cstaber
Actually, I just realized it was only working because I didn't use a schema name in the FROM. When you use a schema.table_name - it doesn't pick up the alias. When you just list the table name by itself without the schema prefix, it then picks up the alias.
This holds true every time so far. So I guess it's not quite fixed

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

cstaber · June 10, 2014, 8:54am

Oh yes, that is true. I was using the schema name I was connected as.

phartzsch · June 10, 2014, 11:21pm

Hi,

I have the same problem. My logon schema is another then my default schema. Why doesn’t work FROM SCHEMA.T_TABLE_NAME anymore?

mstaszew · June 11, 2014, 6:56am

I think this is the same issue as reported by cstaber, but to be sure is this your scenario?

Logged in as schema A.
Default schema dropdown set to schema B.
Query looks something like "select i. from B.tablename" and "i" is replaced by "tablename" when you select an item from the popup.

Is that your setup?

Thanks,

Michael

On 06/11/2014 02:21 AM, phartzsch wrote:

RE: Toad 12.5 - Code Assist not using table alias!

Reply by phartzsch
Hi,

I have the same problem. My logon schema is another then my default schema. Why doesn't work FROM SCHEMA.T_TABLE_NAME anymore?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

mstaszew · June 11, 2014, 7:25am

This is fixed for first 12.6 beta.

Thanks,

Michael

On 06/10/2014 11:30 AM, cstaber wrote:

Toad 12.5 - Code Assist not using table alias!

Thread created by cstaber
If I have something like this:

SELECT

i.

FROM

 dss_icsmgt_stage.e_cp_ics_initiative i

When I get to the "i." and select a column from the menu, rather than it displaying "i.column_name", it changes to "e_cp_ics_initiative.column_name". I upgraded from 12.1 and it was working with the aliases before. I tried going through the options menu,
but couldn't seem to find anything.

Any help would be greatly appreciated!

Thanks!

-Chris

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

danny.torres · June 13, 2014, 6:49am

Hi Michael,

I got a SR with the same issue.

I see it will be fixed in 12.6.

Could I get a CR defect ID to give to my user and to create a solution?

Thank you.

mark.s.pedrick · April 21, 2015, 6:15pm

I am running Toad 12.6.0.53 and it is definetly NOT fixed. Code assist bubble worked sporadically, then only when logged in with Windows Admin rights and now not at all.

I’ve used the Utilities and created new user files to no avail. I’ve checked and unchecked Public synonyms as well as checked and unchecked Synonyms - all to no avail.

Is there anyone who can assist getting Code Assist working in 12.6.0.53?

Thank you

Update - OK, I may be on to something. I got Code assist to work using table aliases on 12.6.0.53 but only if a table is listed once and only once in the query with a single alias. If you need to join the same table more than once in a query using different aliases, it stops working for all aliases within the query.

stalsy · May 31, 2015, 6:16pm

I am also running Toad 12.6.0.53 and it is definetly NOT fixed.

I’m running Toad on a WIN 7 VM machine. I seems to work for a while after I reboot the VM, however soon after it starts to work only for some tables and finally it only works when I use it for a fully qualified table (Press Ctrl + T after the period of Schema.TableName. ).

I tried restarting Toad only (without rebooting) but this does not solve the issue.