First I would like to give a big "thank you" to all on who work on the SQL Prompt product, including those who service this forum. I was a (pleasantly) surprised to find it free until September.
I was glad to see many of the suggestions from this board incorporated into this release version. Offhand I've noticed:
More Visual Studio-esque Intellisense. For instance hitting CTRL+SPACE on a partial object name brings up the object list pre-filtered.
The Intellisense window is less prone to closing when hitting backspace.
TAB, ENTER and "." are now all valid Intellisense accept keys.
Option for Grouping Object Types
Local Variable support (Actually I noticed that last beta too)
Online Help is up and running
Complete Overhaul of the Snippet Management UI Including Preview!
However a whole new set of problems are included in this release:
I have a Snippet defined as such:
Shortcut: be
Code:
BEGIN
{TAB}
END{UP}{RIGHT}
This was working as expected in the last beta, with the caret on the line between the BEGIN and END indented 1 tab. However in the release version the caret is on the "E" of END. I then tried to preview it and I got a weird infinite loop that completely locked up my PC (I had to CTRL+ALT+DELETE to break the cycle and then SQL Prompt was unresponsive).
The schema browsing engine had degraded to the point where I could not get it to bring up anything. At first it was working flawlessly, then after some use it started to take some "coaxing" to come up. (Repeated use of CTRL+SPACE, re-writing the SQL Statement, hitting tab after the keywords). Then it stopped responding at all. This is similar to what the beta did. I would have to exit and rerun SQL Prompt. However after going through this cycle a few times it didn't work at all. I tried the "Clear Cache" button but it did not seem to have an effect. I've uninstalled, reboot, reinstalled and still had this problem. Only after uninstalling, removing my {profile}\Local Settings\Application Data\Red Gate folder, HKLM\Software\Red Gate and HKCU\Software\Red Gate Registry keys then reinstalling did I finally get it back. It would be nice to have the installer do that cleanup automatically as an option. Oh and one other thing I should note that during this "dark period" the Snippets and Local Variable features still worked. I don't know if there is some sort of extended logging option but if there is I'm willing to turn it and and submit the logs if this would be helpful.
Also the EULA on the installer still indicated a 14 day trial period at the end you agree to either purchase or uninstall to software.
Hi Chris,
I was glad to see many of the suggestions from this board incorporated into this release version. Offhand I've noticed:
More Visual Studio-esque Intellisense. For instance hitting CTRL+SPACE on a partial object name brings up the object list pre-filtered.
The Intellisense window is less prone to closing when hitting backspace.
TAB, ENTER and "." are now all valid Intellisense accept keys.
Option for Grouping Object Types
Local Variable support (Actually I noticed that last beta too)
Online Help is up and running
Complete Overhaul of the Snippet Management UI Including Preview!
However a whole new set of problems are included in this release:
I have a Snippet defined as such:
Shortcut: be
Code:
BEGIN
{TAB}
END{UP}{RIGHT}
This was working as expected in the last beta, with the caret on the line between the BEGIN and END indented 1 tab. However in the release version the caret is on the "E" of END. I then tried to preview it and I got a weird infinite loop that completely locked up my PC (I had to CTRL+ALT+DELETE to break the cycle and then SQL Prompt was unresponsive).
The schema browsing engine had degraded to the point where I could not get it to bring up anything. At first it was working flawlessly, then after some use it started to take some "coaxing" to come up. (Repeated use of CTRL+SPACE, re-writing the SQL Statement, hitting tab after the keywords). Then it stopped responding at all. This is similar to what the beta did. I would have to exit and rerun SQL Prompt. However after going through this cycle a few times it didn't work at all. I tried the "Clear Cache" button but it did not seem to have an effect. I've uninstalled, reboot, reinstalled and still had this problem. Only after uninstalling, removing my {profile}\Local Settings\Application Data\Red Gate folder, HKLM\Software\Red Gate and HKCU\Software\Red Gate Registry keys then reinstalling did I finally get it back. It would be nice to have the installer do that cleanup automatically as an option. Oh and one other thing I should note that during this "dark period" the Snippets and Local Variable features still worked. I don't know if there is some sort of extended logging option but if there is I'm willing to turn it and and submit the logs if this would be helpful.
Also the EULA on the installer still indicated a 14 day trial period at the end you agree to either purchase or uninstall to software.