How can we help you today? How can we help you today?

Multiple tab annoyance while writing queries.

While writing stored procedures in Query Analyser or Enterprise Manager I frequently need to tab multiple times so that the stored proc is readable, i.e. for IF statements or Large SQL statements. But with SQL Prompt enabled its difficult to tab like this as it begins prompting instead of tabbing, e.g.

If I type :

BEGIN
_________SELECT field FROM
___________________TABLE
_________WHERE
___________________x=1 AND
[enter] and press [tab] [tab], it automatically selects the first field in table and cancels the tab I just did.


I don't think tab should give the field prompt, it should only be on [ctrl]-[space] to make it consistent with Visual Studio or perhaps an awareness or how the page is tabbed when [enter] is pressed (also like visual studio).

Thanks.

Oli.
obeale
0

Comments

3 comments

Sort by
  • Bart Read
    Hi obeale,


    Thanks for your feedback. I think you raise an interesting point here. In Visual Studio tab will also select the current candidate in the intellisense list, however in C# it's generally not so necessary to use TAB to indent if you have VS's smart-tabbing feature switched on. Whereas of course when editing SQL there is currently no such thing as smart-tabbing since there's no set-in-stone standard for formatting SQL the way there is C#, C++ etc, hence you end up TABbing a lot more just to indent your code nicely. So it might be worth just treating TAB as a normal alphanumeric key rather than as a key for selecting intellisense candidates.

    We'll certainly take this into consideration for the new version.


    Many thanks,
    Bart Read
    0
  • Tilman
    Hi Oli,

    there is an option on the Options tab where you can turn off tab as a trigger key.

    Tilman
    Tilman
    0
  • obeale
    Perfect, thanks !
    obeale
    0

Add comment

Please sign in to leave a comment.