Print Thread
Multiple selection from dropdown lists
#65198 12/17/23 11:21 AM
Joined: Sep 2003
Posts: 387
London, UK
Member
OP Offline
Member
Joined: Sep 2003
Posts: 387
London, UK
In PL/SQL Developer 12, I can select multiple items from lists using control-click, but this doesn't seem to work for some of my colleagues. Is there some setting that could affect this? I've looked but I can't see anything likely, and I'm not sure why there would be a preference setting for it anyway.

Re: Multiple selection from dropdown lists
William Robertson #65203 12/19/23 09:24 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you provide an example of such a list?


Marco Kalter
Allround Automations
Re: Multiple selection from dropdown lists
William Robertson #65206 12/20/23 10:07 AM
Joined: Sep 2003
Posts: 387
London, UK
Member
OP Offline
Member
Joined: Sep 2003
Posts: 387
London, UK
For example, if I start typing a query like
SQL Query
select s. from user_sequences s
so that Code Assistant pops up a list of columns to expand "s."

I have noticed colleagues painstakingly selecting one item at a time, but when I suggest using control-click to select multiple items, it only lets them pick one.

[Linked Image from williamrobertson.net]

(This is from my home PL/SQL Dev 14 setup as I can't take screenshots from work, but it works fine for me in both versions.)

Re: Multiple selection from dropdown lists
William Robertson #65213 12/21/23 09:43 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
This does seem to work just fine in 15.0. Can you provide an example from your colleagues where this does not work? Perhaps I can see a restriction.


Marco Kalter
Allround Automations
Re: Multiple selection from dropdown lists
Marco Kalter #65214 12/21/23 12:19 PM
Joined: Sep 2003
Posts: 387
London, UK
Member
OP Offline
Member
Joined: Sep 2003
Posts: 387
London, UK
I’m not sure how I would do that, as it would just be the same scenario but they can only pick one item off the list where I can pick multiple items, using the same version of PL/SQL Developer (12, though lucky colleagues in another office have 15 but the same issue) and Windows 10. I was just wondering if there are any factors that might affect it. Or maybe they are just doing it wrong somehow.

Re: Multiple selection from dropdown lists
William Robertson #65216 12/22/23 09:34 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
It can depend on the position in the statement. For the field list you will get an (all) option and multi-select:

Code
select s.| from all_sequences s

For the where clause will will not get the (all) option and multi-select:

Code
select s.* from all_sequences s
where s.|

Perhaps this can explain it?


Marco Kalter
Allround Automations
Re: Multiple selection from dropdown lists
Marco Kalter #65218 12/24/23 10:15 AM
Joined: Sep 2003
Posts: 387
London, UK
Member
OP Offline
Member
Joined: Sep 2003
Posts: 387
London, UK
No, they seem to have the issue in the select list. Maybe they are just doing it wrong somehow. I'll see if I can try it myself on their PC, though it's not always possible when you are screen-sharing remotely.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.059s Queries: 13 (0.024s) Memory: 2.5271 MB (Peak: 3.0431 MB) Data Comp: Off Server Time: 2024-05-18 22:55:02 UTC
Valid HTML 5 and Valid CSS