Toad World® Forums

pick-list not working in some cases


#1

select * from dba_role_privs drp where drp. – displays an empty popup; same for any dba_ object

select * from sys.dba_role_privs drp where drp. – correctly displays list of columns

select * from . – produces List out of bounds error

select * from . – correctly displays list of my objects


#2

Can you email me your Toad.ini?

michael.staszewskiquest.com

Thanks,
Michael

On 01/10/2014 05:03 PM, droeschley_109 wrote:

pick-list not working in some cases

Thread created by droeschley_109
select * from dba_role_privs drp where drp. – displays an empty popup; same for any dba_ object

select * from sys.dba_role_privs drp where drp. – correctly displays list of columns

select * from . – produces List out of bounds error

select * from . – correctly displays list of my objects

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

Thanks for your INI.

Statement 1: You’re options exclude public synonyms from the results. In 12.1 GA the popup would not display at all. The beta is showing an empty one. The popup should not be shown at all in the beta with your options.

Statement 2: That statement hits the view directly and you have views included in your options so that’s why it shows.

Statement 3: I don’t get a list index out of bounds. Is this still an issue in the latest beta (12.5.0.13)?

Michael

On 01/10/2014 05:03 PM, droeschley_109 wrote:

pick-list not working in some cases

Thread created by droeschley_109
select * from dba_role_privs drp where drp. – displays an empty popup; same for any dba_ object

select * from sys.dba_role_privs drp where drp. – correctly displays list of columns

select * from . – produces List out of bounds error

select * from . – correctly displays list of my objects

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.


#4

#1 - I recall now that I did uncheck public synonyms because I did not want to see all the useless synonyms that start with “/” and couldn’t see any way to exclude them.

#3 - yes but only under certain conditions:

select * from . – works fine the first time

select * from a1

– when I go back and change to .

– I get list index out of bounds or I get a popup that appears to be doing something and then it disappears.


#5

This is the scenario for the out-of-bounds error:

  1. select * from <table_name> a1

where a1. is null

  1. go back and change <table_name> to .

pick-list popup will appear and chug and then list-index-out-of-bounds error.


#6

Thanks for the steps. I’ll check it out in the morning.

On Jan 14, 2014, at 6:31 PM, “droeschley_109” bounce-droeschley_109@toadworld.com wrote:

RE: pick-list not working in some cases

Reply by droeschley_109
This is the scenario for the out-of-bounds error:

  1. select * from <table_name> a1

where a1. is null

  1. go back and change <table_name> to .

pick-list popup will appear and chug and then list-index-out-of-bounds error.

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

Please send the Toad.el file from your user files folder to me offline.
michael.staszewski@quest.com

I’m unable to reproduce. I’m logged in as my schema and I have a table named emp.

I typed into the editor select * from emp a1 where a1 is null. I went back to the a1 in the where clause and added the ‘.’ and waited for the list. I selected the comm column. I deleted ‘emp’ from the from clause and typed ‘scott.’ and waited for the list.
It displayed without error and I selected the emp table owned by scott. I’m using the Toad.ini that you emailed last week.

Michael

On 01/14/2014 06:31 PM, droeschley_109 wrote:

RE: pick-list not working in some cases

Reply by droeschley_109
This is the scenario for the out-of-bounds error:

  1. select * from <table_name> a1

where a1. is null

  1. go back and change <table_name> to .

pick-list popup will appear and chug and then list-index-out-of-bounds error.

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.


#8

SELECT * FROM chx_dbt. a1

WHERE a1. IS NULL

I can produce the error with the above statement at will The 1st time I click ctrl-T after the dot after CHX_DBT (not my schema), it works fine. Hit Escape and try again - I get the error.

Sent Toad.el to you offline.


#9

I just noticed that if I change the schema-name, again it works the 1st time and errors on subsequent tries.


#10

Ok, I can reproduce this not on the 2nd launch.

On 01/15/2014 01:36 PM, droeschley_109 wrote:

RE: pick-list not working in some cases

Reply by droeschley_109
SELECT * FROM chx_dbt. a1

WHERE a1. IS NULL

I can produce the error with the above statement at will The 1st time I click ctrl-T after the dot after CHX_DBT (not my schema), it works fine. Hit Escape and try again - I get the error.

Sent Toad.el to you offline.

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.


#11

Typo… Ok, I can reproduce this now on the 2nd launch.


#12

Fixed in next beta.

On 01/15/2014 01:36 PM, droeschley_109 wrote:

RE: pick-list not working in some cases

Reply by droeschley_109
SELECT * FROM chx_dbt. a1

WHERE a1. IS NULL

I can produce the error with the above statement at will The 1st time I click ctrl-T after the dot after CHX_DBT (not my schema), it works fine. Hit Escape and try again - I get the error.

Sent Toad.el to you offline.

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.