Red Gate forums :: View topic - Auto completion insertion keys behaviour
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

Auto completion insertion keys behaviour

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
sfackrell



Joined: 13 Jul 2010
Posts: 2

PostPosted: Tue Jul 13, 2010 10:59 am    Post subject: Auto completion insertion keys behaviour Reply with quote

Would be much better if when you chose space bar as an insertion key and there was only one suggestion, e.g. after you type "sel" it completed immediately rather than displaying the only suggestion and making you press the space bar again.

This is annoying and also different to how VS2008 intellisense works. Compare behaviour with typing "priv" in VS and pressing Ctrl+Space

1. SQL Prompt => S>E>L>Ctrl+Space>Space * => outputs SELECT
2. VS => P>R>I>Ctrl+Space => outputs private (C#)

* this step is unnecessary when there is only one suggestion.

Maybe you can change this behaviour in the options but I can't see how.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 683
Location: Cambridge

PostPosted: Wed Jul 14, 2010 2:21 pm    Post subject: Reply with quote

Many thanks for your post.

Can you kindly check whether your option 'SQL Prompt 4 --> Options --> Behavior --> Automatically trigger suggestions' is selected or not?

This will reduce your steps to:

1. SQL Prompt => S>E>L> => outputs SELECT
2. VS => P>R>I>Ctrl+Space => outputs private (C#)

Kindly let me know if this setting is selected and still you have to press Ctrl + Space.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
sfackrell



Joined: 13 Jul 2010
Posts: 2

PostPosted: Wed Jul 14, 2010 4:19 pm    Post subject: Reply with quote

Thanks for your reply. Yes, this setting is checked. It's not that I don't want to press Ctrl-Space. I want to press Ctrl-Space but when I do and there is one and only one suggestion it should complete to this suggestion straight away, rather than leave a popup on screen.

Regardless of how you type, if you have the letters SEL in the window and position the cursor to the right of L and press Ctrl-Space, it should change to SELECT immediately, not display a list with SELECT as the only valid suggestion.

Compare this with well established behaviour in Visual Studio where only one valid suggestion means no need to press anything more than Ctrl-Space. E.g. open a new C# console application and type whi in the Main proc. Press Ctrl+Space. No drop-down, just autocompletion because while is the only valid choice based on the namespaces available.

There also appears to a problem with these options and join syntax

Reserved keywords: UPPERCASE
Built-in functions: lowercase
Built-in data-types: lowercase

Then type left outer join => left OUTER JOIN or worse, type LEFT OUTER JOIN => left OUTER JOIN

And can you stop the indentation after pressing return because it's often wrong? E.g. type

SELECT *
FROM sys.objects
WHERE name = 'me'
AND create_date = '20100630'

and then press enter a few times. Cursor is still indented? Should go back to far left after one line feed.

It's a great tool in principle but as when I tested the beta a few years back there are still too many little annoyances (for me anyway)[/img]
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 683
Location: Cambridge

PostPosted: Tue Jul 20, 2010 10:14 am    Post subject: Reply with quote

Many thanks for your e-mail.

We appreciate your feedback and hence logged this as a feature request in our internal tracking system whose tracking id is SP-3283.

It will be reviewed by product manager and than marked for the next release.

I will update you as soon as it is incorporated.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group