SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Keyword inserted when enter clicked on alias

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Keyword inserted when enter clicked on alias
Author Message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Keyword inserted when enter clicked on alias Reply with quote
v 5.2.29 SQL

Code:
SELECT d.name, d.is_cdc_enabled
FROM sys.databases d


Place the cursor next to d and hit enter. d is replaced with DELETE. I've also seen it with c getting changed to CROSS APPLY.
Tue Apr 05, 2011 1:25 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2109

Post Reply with quote
It might be because I've altered most of the settings but I don't experience this issue. You don't have snippets d for DELETE and c for CROSS APPLY with ENTER as Key Char, do you?
Tue Apr 05, 2011 6:31 pm View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
no, no snippets for that. In fact, DB options are: SQL Keywords no, Suggest after: 2. But it is checked on History. Pretty odd.
Wed Apr 06, 2011 8:52 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Please check if any snippets have "Enter" key set as their trigger.
Wed Apr 06, 2011 9:39 am View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
Quote:
But it is checked on History.
Referring the SQL Keywords: Should be "But it is checked on List Items"


Everything is triggered by Ctrl-Enter, except the built in begin and begin try.
Wed Apr 06, 2011 10:10 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Please try disabling history cache/prompts to exclude their interference (Options dialog -> DB Options -> SQL Server -> History -> History Items Shown in Lists -> 0). When disabled, cached historical items shouldn't appear in the green portion of popups.

Sorry for a silly question, you don't have any other add-on or feature enabled outside SQL Assistant that might be expanding d into DEELTE when Enter key is pressed?
Thu Apr 07, 2011 8:11 am View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Reply with quote
History was already disabled (since its release). But yes, it was SSMS Tools that did it. It has it's own snippet thing. I usually keep it disabled. Don't know how it got reenabled, unless it was an upgrade of their software that blew away my settings.
Thu Apr 07, 2011 12:16 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.