Suggestion Inserted Instead of Indenting

MikeyC

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.)

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.