Can't make a dupicate format [9.5.449]

Can't make a dupicate format [9.5.449]

I want to make a duplicate format from the default and make some change to it.

Here are the steps:

Right Click on SQL Assistant icon on the Taskbar
Click Options
Click Code Formatting Tab
Click Default Style
Click "Copy Selected Format Style" 4th Icon from the left
It shows new format T-SQL Default Style (Copy)
Make change in (header)
Hit Test
Hit Apply
Everything looks good here
Hit Ok to exit

Now Click Options on Taskbar again
Click Code Formatting tab
Everything does not save at all.
It looks like brand new with all default.

I try to export the config file and import back.
Does not work either.

I also look at AppData\Roaming\SQL Assistant\9.5
It seems like nothing update in this folder (SQLAssist.sas)

Please help.

Last edited by richardrut on Thu Feb 01, 2018 11:11 am; edited 1 time in total

If you have any development environments running, please close them, and then try again.

If that doesn't help, try restarting SQL Assistant in Run as Administrator mode

Can't make a dupicate format [9.5.449]

It still does not work by closing all ssms.

I don't have admin since this is company laptop.

Do you have another workaround? I think it is an inconvenience while I developed a code and tried to add a format. I need to close all ssms windows. then change / add the format and reopen all the tabs.

Thanks,

If you use it with SSMS, instead of using global options that may require admin rights, use SQL Assistant -> Option menu in SSMS. Would you please try and see if that works?

It helps by restart computer. It is an inconvenience but it works now.

It happens to me couple times already (Not Often). I try to find when it's crash and what the action before that.

---------------------------------------------------------------------------------------------------
One more thing, I found that when I used the menu from right click mouse. Sometimes it does not work.

Say I want to add new a code snippet. It does not show the dialog.

If I used SQL Assistant Menu on the bottom right. It works all the time.

Could you please help me understand what's shown on your screenshot?

Last edited by SysOp on Fri Feb 02, 2018 11:34 am; edited 1 time in total

Let me try to explain again. SQL Assistant menu can call from three places in SSMS (Full Mode).

1. The SSMS Menubar on the top of the window
2. Right Click anywhere on the code page
3. SQL Assistant icon on the bottom right

Say I want to add a new code snippet.

-I click right click on my mouse anywhere from the code screen (2).
-It shows a popup menu as pic 2.
-I click Code snippet > Add snipper.
-It shows no dialog to add a code.

However, if I click on the SQL Assistant logo (3) on the bottom right of the page (pic1).
-I do the same
-I click left click on my mouse.
-It shows a popup menu as pic 2.
-I click Code snippet > Add snipper.
-It shows a dialog to add a code this time. I can a new snippet.

So I know if there is no show on the dialog, I need to use the SQL Assist Icon on the bottom of the screen.

Thank you very much for all your help.

I think it's by design. The "add snippet" menu in SSMS has different behavior. if you enter snippets code directly in the editor, or select an existing SQL statement or it's part, and hid the "add snippet" menu, it will add the highlighted text as a code snippet. But if nothing is selected, there is nothing to add, that's why nothing happens. I think it would be nice if it could at least show a message prompting to select some text then use the menu, or some kind of a hint for what's expected.

The idea here is like if you keep typing every day FROM some.table JOIN some_other.table ON ... and you are tired of that and want to have a snippet that inserts that for you, right in the editor, you select that text and use "add snippet" menu.

The global menu available in SQL Assistant icon on the bottom right (in the system tray area) does the same thing as above, but also, if it cannot find anything selected or the editor isn't active, it opens an empty Add snippet dialog so that you can enter brand new snippet from scratch.

SysOp wrote:

I think it's by design. The "add snippet" menu in SSMS has different behavior. if you enter snippets code directly in the editor, or select an existing SQL statement or it's part, and hid the "add snippet" menu, it will add the highlighted text as a code snippet. But if nothing is selected, there is nothing to add, that's why nothing happens. I think it would be nice if it could at least show a message prompting to select some text then use the menu, or some kind of a hint for what's expected.

Mine does show a message, FYI. I was checking it out after he explained what was happening.

I have to correct myself. I tried to reproduce this issue, and on my test system I always get a message like this one.

I will keep trying it with SSMS 2016, I think that is the version that you use.