Suggestion Inserted Instead of Indenting

CodantiMCodantiM Posts: 245
edited September 27, 2010 8:43AM in SQL Prompt Previous Versions
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.)

Comments

  • 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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.