Comments
Sort by recent activity
often I have the same issue. Would be fine to fix it. / comments
often I have the same issue. Would be fine to fix it.
and I miss the workaround mentioned here in the https://documentation.red-gate.com/ss3/troubleshooting workaround instructions can be found only here in the forum. / comments
and I miss the workaround mentioned here in the https://documentation.red-gate.com/ss3/troubleshootingworkaround instructions can be found only here in the forum.
@ostandage I am using the latest versions 10.6.6. 0.2.6 but as I explained the files are different. SSMS configuration file contains one more entry on top which is missing in the ADS version: ```json "metadata": { "id": "de9438b0-12d2-4ff9-9cce-c0e23dd1001f", "name": "aisberg" }, ``` And it looks like this block is required by the SSMS version and the VS version. That's why I created this feature request. As I described: If I (or you) copy the config file from ADS app, not containing this part, in the SSMS config folder and add the extension `.json` to this file then this causes errors in SSMS SQL Prompt and VS SQL Prompt. I think the SSMS and VS versions are parsing these files and looking for this specific content. I tried several things, deinstalled and reinstalled SQL Prompt, before I found that the existence of this "invalid for SSMS SQL Prompt" configuration file causes the error. You should be able to reproduce the issue. Maybe it could be also a good idea to create a bug for SSMS SQL Prompt based on my description. Germo / comments
@ostandage I am using the latest versions 10.6.6. 0.2.6but as I explained the files are different. SSMS configuration file contains one more entry on top which is missing in the ADS version:```json...
the post is not shown as in the editor, I try again:
"dml": {
"clauses": {},
"listItems": {},
"addNewLineAfterDistinctAndTopClauses": true,
"collapseStatementsShorterThan": 75,
"collapseShortSubqueries": true,
"collapseSubqueriesShorterThan": 75,
"listItems": {
"placeGroupByAndOrderByOnNewLine": "always",
"placeFromTableOnNewLine": "always",
"placeWhereConditionOnNewLine": "always"
}
},
Select
Object1.[RepoObject_fullname] As ReferencingObjectName
, Object1.[RepoObject_type]
, Object2.[RepoObject_fullname] As ReferencedObjectName
, Object2.[RepoObject_type]
--, Object1.[RepoObject_guid]
--, Object2.[RepoObject_guid]
From
[graph].[RepoObject] As Object1
, [graph].[ReferencedObject] As referenced
, [graph].[RepoObject] As Object2
Where MATCH(
Object1-(referenced)->Object2)
And Object1.[RepoObject_type] In ( 'u', 'v' )
And Object2.[RepoObject_type] In ( 'u', 'v' )
Order By
Object1.[RepoObject_fullname]
, Object2.[RepoObject_fullname]
/ comments
the post is not shown as in the editor, I try again:
"dml": {
"clauses": {},
"listItems": {},
"addNewLineAfterDistinctAndTopClauses": true,
"collapseStatementsShorterThan": 75,
...
@AdrianB Thank you! This is exactly, what I was searching for. Could you consider adding this hint in the documentation of the extension? Then other users also would be able to easy find it. / comments
@AdrianB Thank you! This is exactly, what I was searching for.Could you consider adding this hint in the documentation of the extension? Then other users also would be able to easy find it.
I still from time to time try to use the sql-prompt formatting. But normally I give up. Because it is very hard to change the configuration if there is no GUI like in SSMS. I can't use SQL Prompt in SSMS because I have no license. Could you consider publishing the complete list of all possible settings for formatting? If a user can see, what is possible, then it will be much easier to find the possible settings. For now, I switched back to Poor Mens formatter, because it is free and is available in SSMS and in VSC. But I am not really happy with the result. It would be fine to use the same free formatter in VSC, ADS and SSMS and to be able to configure it a bit. Especially, when working in a team in an open source project, then there should be some free formatting options. / comments
I still from time to time try to use the sql-prompt formatting. But normally I give up. Because it is very hard to change the configuration if there is no GUI like in SSMS. I can't use SQL Prompt i...
@ostandage I found the link in the first topic of this forum here. I see it is a very new version. And it is easier now to see possible values using the path on the top. Of course, it would be easier to use the formatting settings dialogs of the plugin in SSMS. I know reg-gate plugins from some projects in the past where I was allowed to use red-gate software. Many years ago I even got a T-shirt "friends of red-gate" and I got a developer license to be able to use and to promote. But it is often hard to promote tools because there is one budget and process for consulting and another process for software. Often software needs to be "listed" to be allowed. So the only chance for me to use red-gate software was when the company will buy these tools for all developers. In most other projects I need to use what they have, for example the features in SSDT. ADS can be installed per user, without admin rights, and that's why it is easy to use in any project. And I am looking for methods to be used in projects where I don't get admin rights. Would be fine to get free refactoring also in ADS, with SQL-Prompt. Currently, the free ways are SSDT or the old standalone APEXSql Refactor. / comments
@ostandage I found the link in the first topic of this forum here. I see it is a very new version. And it is easier now to see possible values using the path on the top.Of course, it would be easie...
@ostandage OK, I got it. I need to place the Cursor between the ":" and the current value, then on CTRL-SPACE I get a full list. This works. My ADS Version of SQL Prompt is 0.2.4 ADS is showing me that this is the current version. And there is no download link in the readme file or in ADS. Normally I get the download link only when I get a notification in ADS about a new version. Maybe you could add the download link in the readme file? It is hard to find the right web link of the plugin because ADS has a restricting encapsulation to avoid users to move to the original resource site using a normal browser. I don't use SQL Prompt in SSMS because it is not free. I used the free APEX SQL tools for many years instead of red gate non-free tools. But now Apex stopped to deliver freeware. That's why now I have a look on red gate products again. / comments
@ostandage OK, I got it. I need to place the Cursor between the ":" and the current value, then on CTRL-SPACE I get a full list. This works.My ADS Version of SQL Prompt is 0.2.4ADS is showing me th...
There is a big issue: before I get some hint for possible values I need to start to write a value with any letter. But when I don't know the allowed values I will not find them. For example, I want to replace the "lowercase" by some valid value, but if I remove the "lowercase" I get no hint. Now I need to try the whole alphabet from a to z, and sometimes I will get some possible values, sometimes not. But I will never get the whole list of all possible values. This is very hard to use. I think I could find a style I need, but it is too complicated without any documentation of available values for all settings. / comments
There is a big issue: before I get some hint for possible values I need to start to write a value with any letter. But when I don't know the allowed values I will not find them. For example, I want...
This is a bit helpful, but it could be improved. When I create a new formattingstyle I am asked to select a master. After this I have a ready json file. I miss a way to see and compare all predefined styles to get an idea how they are different. When I hoover on the left part of the definition I get some help, this is fine. But there is no hint on hoovering the possible values. Maybe this is not supported by ADS. I first need to delete the content, and only then I get a list of available values. And I can do this only value per value. I miss an overview. I think you could or better should add a description of possible content and values to the readme file of the extension. / comments
This is a bit helpful, but it could be improved.When I create a new formattingstyle I am asked to select a master. After this I have a ready json file.I miss a way to see and compare all predefined...