Comments
Sort by recent activity
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.
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 ...
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) ...
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...
* 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...
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!
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 ...
* Do you like the ability to filter the candidates by type? (CTRL plus LEFT
ARROW or RIGHT ARROW)
Yes. I would like to see a filter that is limited to columns from objects in the FROM clause. Right now it is very inconvenient to pick columns. It would be nice to have mulitple hierarchical filters. For example, Table and Columns.
* Is it the right size to start off with?
Its fine. I would like to see a more solid border. Sometimes, it blends in with my code.
* Does it work the way you think it should?
Its a start. I would like it to work similar to the Intellisense for Visual Studio .NET and CodeRush.
* Does it show all the information you need about a candidate? E.g. showing the type information for columns.
I think the Candidate list should NOT pop up if its empty. At least show items that are similar or don't come up at all. / comments
* Do you like the ability to filter the candidates by type? (CTRL plus LEFT
ARROW or RIGHT ARROW)
Yes. I would like to see a filter that is limited to columns from objects in the FROM clause. Right...