Activity overview
Latest activity by brian26ny
Candidate and script window does not respond to Mouse Wheel
When I attempt to use the Mouse scroll wheel on either window, the SSMS window moves up/down instead. I clicked inside the windows to make sure it was in focus but no luck.
It would be nice to have...
I personally like the TAB. But I wouldn't be bothered by the SPACE bar as long as there is an option to change it. / comments
I personally like the TAB. But I wouldn't be bothered by the SPACE bar as long as there is an option to change it.
Feature request: Fine tune auto-popup
I would like to have the ability to specify when the auto-popup comes up. I have worked with it disabled for awhile but I do miss it. When I have it set to auto-popup, it gets annoying when it pops...
1) When I have a stored procedure file opened in the SSMS editor, the SQL window for the candidate list does not update itself properly for EXEC when I am typing the SQL out. For example: EXEC sp_Ad ==> view sp_AddUser
if I backspace and type EXEC sp_C ==> view is still sp_AddUser
The funny thing is that this does not occur when I am in a new Query window. It only seems to happen when I am editing a stored procedure file.
2) The candidate is case-sensitive. If I don't type the proper case, I usually end up with a blank list. / comments
1) When I have a stored procedure file opened in the SSMS editor, the SQL window for the candidate list does not update itself properly for EXEC when I am typing the SQL out. For example:EXEC sp_A...
1) I would love it if SQL Prompt would maintain variables for me. If I were to change the name from @count to @numRows, it would do it for me. I would not have to search and replace everything.
2) I know this was mentiond. I would like to see snippets for everyday tasks like declaring variables, variable types, creating table variables, writing out TRY CATCH blocks, loops, if statments, joins, calling stored procedures, calling functions, etc.
For example:
dvi count ==> DECLARE @count INT
3) Candidate list for stored procedures, functions, views, etc. Parameters. First, I would like to be able to use the name, type, and description if available by selecting a parameter and have it explicitly show up in the code.
For example:
EXEC sp_helptext @objname:='sp_help', @columnname:=NULL
4) I would love it to have Refactoring capabilities. For example, the ability to specify code to be put into a separate stored procedure/view/function/etc, and have the parameters set, and the calling code set as well.
Hope I didn't repeat too much! / comments
1) I would love it if SQL Prompt would maintain variables for me. If I were to change the name from @count to @numRows, it would do it for me. I would not have to search and replace everything.
2) ...
Tilman wrote:
I was able to reproduce something when i split the query window. I get the following exception.
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'This SqlPromptEngine instance can no longer be accessed because it has been disposed of.'.
Is that what you are getting, or is it something different?
Hi Tilman,
No. I got the following:
System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: ordinalPosition
at RedGate.Util.EventHandlerSet.Fire(Object eventKey, Object sender, EventArgs args)
at RedGate.Util.EventHandlerSet._1.Fire(Object eventKey, Object sender, EventArgs args)
at _43._1(CaretPosition , CaretPosition )
at _43.set_CaretPosition(CaretPosition value)
at _43.RemoveFromScript(CaretPosition startPosition, CaretPosition endPosition, CaretPosition caretPosition)
at RedGate.SqlPrompt.Engine.SqlPromptEngine.RemoveFromScript(CaretPosition startPosition, CaretPosition endPosition, CaretPosition caretPosition)
at _12.OnChangeLineText(TextLineChange[] pTextLineChange, Int32 fLast)
-Brian / comments
Tilman wrote:
I was able to reproduce something when i split the query window. I get the following exception.
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'This ...
Tilman wrote:
Hi brian26ny,
You can turn off the auto-popup on the options dialog.
Regards,
Tilman
Thanks Tilman, totally missed it! [image] / comments
Tilman wrote:
Hi brian26ny,
You can turn off the auto-popup on the options dialog.
Regards,
Tilman
Thanks Tilman, totally missed it!
Bug: Auto Alias Does Not Account For Existing Text
Type in the following SQL:select * from sys
and hit Ctrl+Space. Select 'syscacheobjects'. You will get:select * from [sys].[syscacheobjects] AS s
Put the cursor at the end of 'syscacheobjects' and ...
Its a start. I would like it to work similar to the Intellisense for Visual Studio .NET and CodeRush.
Can you be a bit more specific about how you'd like to see this work please?
I would like the Ctrl+Space functionality to have more control. Many times, the candidate list would pop up when I am not expecting or need it. I am already "programmed" to hit ctrl+space to pull up the list in VS.NET. At the very least, maybe an option to limit/stop the automatic display of the candidate list. It is like a catch-22 where when it works its great but when it doesn't, its annoying. That's why I would rather have the ability control the display of the candidates list. / comments
Its a start. I would like it to work similar to the Intellisense for Visual Studio .NET and CodeRush.
Can you be a bit more specific about how you'd like to see this work please?
I would like ...
* What do you think of the automatic aliasing of tables?
Its ok with me. I prefer to have the aliasing work. It is very inconsistent and at times wrong with the candidate listings.
* Do you like the auto insertion of table names when you select a column?
ok.
* If you insert columns from many tables should the tables be automatically inner joined of should there be some way of choosing left outer / right outer join?
I think a method of picking should be presented,
* Are there more features in the snippets that you would like?
I would like to be able to specify a snippet and provide it one or more table names. From this, a list of columns should be displayed for me to choose from, defaulting to all, once this is done. A complete, "SELECT" for example, SQL statement should be created. That would be cool! / comments
* What do you think of the automatic aliasing of tables?
Its ok with me. I prefer to have the aliasing work. It is very inconsistent and at times wrong with the candidate listings.
* Do you like th...