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

SQL Prompt insert TAB,Space, Enter ????

Hi,

I see that Enter is working different when I select from menu, it insert column name from list + rightmost characters of this name from the current position

To reproduce:
1. start select... from your_table
2. start typing column name let say 'ben..'
3. menu pop ups with available choices
benefit_id
benefit_name
benefit_alt
sp_your_ben1000

4. Down error select on benefit_name
5. ENTER
..see benefit_name inserted on edit screen
..list change a look

** now I know just get way from SQL Prompt

6. ENTER (again)
.. <benefit_nameefit_name> that what I have now????!!!!!!

#6 could be replicated also with TAB as well.

On my option I have in SUggetsion/BEhavior/Insertion Keys
Enter checked ON
TAB checked ON
Space bar ... nothing (OFF)

Is that normal? What I'm missing?????

Thanks
Mario
mario17
0

Comments

3 comments

Sort by
  • Aaron L
    Hi Mario,

    It sounds like you've got the built in intellisense as well as Prompt enabled. You can disable the built in intellisense popping up by going to Tools->Options->Text Editor->Transact-SQL and unticking Auto list members and Parameter information.

    Another user has reported the same issue so I think our installer might not be disabling it in all cases. Can I ask which version of SSMS you are currently running?

    Thanks,
    Aaron.
    Aaron L
    0
  • SullivaR
    Hi Mario,

    I searched the forums because i had a similar issue. I found the problem for me under SQL Prompt - Options -> Suggestions > Behavior > Insertion keys section. I had nothing checked for the insertion trigger here. In this section, one can select which key to press to trigger the insertion from the Suggestion dropdown. Once i checked the key press to use (i chose Space bar) then the insertion action worked. Hope this helps.

    Kind regards,
    Randy Sullivan
    SullivaR
    0
  • budnar
    To answer and add to Aaron's post, I did notices the same behaviour as the one he answered to and I aplied his fix... it worked but I had to restart SSMS.

    My version of SSMS is 10.50.1600.1 and Prompt SQL is 6.2.0.366.

    Hope it helps,
    George.
    budnar
    0

Add comment

Please sign in to leave a comment.