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
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]