 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
Keyword inserted when enter clicked on alias |
|
v 5.2.29 SQL
 |
 |
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 |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
|
|
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 |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Please check if any snippets have "Enter" key set as their trigger.
|
|
Wed Apr 06, 2011 9:39 am |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
 |
 |
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
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 |
|
 |
|
|
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
|
|
|