Suggestion Inserted Instead of Indenting

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Suggestion Inserted Instead of Indenting

Postby CodantiM » Sat Sep 25, 2010 6:18 am

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
Code: Select all
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:

Code: Select all
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:

Code: Select all
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.)
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby Anu Deshpande » Mon Sep 27, 2010 1:43 pm

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: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests