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

Suggestion Inserted Instead of Indenting

I am running version 4.0.4.21 and have found that in some case SQL Prompt will insert a suggestion instead of indenting when I hit TAB 
SELECT 
  DT.bac<selection start>kup_set_id,
  DT.first_family_number,
  DT<selection end>.first_media_number
FROM msdb.dbo.backupfile DT

If at that point I hit TAB I end up with:
SELECT 
	DT.backup_set_id,
	DT.first_family_number,
	DROP TABLE .first_media_number
FROM msdb.dbo.backupfile DT

when I should end up with:
SELECT 
		DT.backup_set_id,
		DT.first_family_number,
		DT.first_media_number
FROM msdb.dbo.backupfile DT

What is weird is after it has done it once, it won't do it again in the same query window. But if I copy the code to a new query window it will do it again. (I understand the the selection ends at the end of a snippet code, but since there is a selection it shouldn't be inserting the snippet.)
MikeyC
0

Comments

1 comment

Sort by
  • Anu D
    Many thanks for your e-mail and apologies for inconvenience caused.

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

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

    I will update you as soon as it is incorporated.
    Anu D
    0

Add comment

Please sign in to leave a comment.