Comments
Sort by recent activity
This is the same for Update , it gives you the UPDATE() function first rather than the the Normal UPDATE
Also IN (INFORMATION_SCHEMA >>>) , and I am sure many more
Will there be a means to disable unwated completions or to re order tehm to allow individual styles and usages ?
Cheers
Mike / comments
This is the same for Update , it gives you the UPDATE() function first rather than the the Normal UPDATE
Also IN (INFORMATION_SCHEMA >>>) , and I am sure many more
Will there be a means to disable ...
Hi Chris
Thanks for that , there are a couple of "completions" that you work around like this , for example the information_Schema one that intercepts IN ,these are in as snippets with shortcuts , eg make it infsc instead of in , I use that shortcut very infrequently so an extra few letters ....
Some however aren't such as the Update() function.
I have created a snippet <up = UPDATE> which now appears above the built in UPDATE() Function , so it fixes the problem , you just have to be carefult not to get carried away and type the UPD as this now goes to the UPDATE() Function.
All in all you can normally get around most of the unwanted insert with an appropriate Snippet of your own .
After all its a small price to pay for the massive typing saving that SQL Prompt gives us . I remain an "addict" , SQL without SQLPrompt would be unthinkable now.
Cheers
Mike / comments
Hi Chris
Thanks for that , there are a couple of "completions" that you work around like this , for example the information_Schema one that intercepts IN ,these are in as snippets with shortcuts , ...
Hi Bart
Corporate SV from Norton , Symatec Antivirus v 10.5.1.500
Cheers
Mike / comments
Hi Bart
Corporate SV from Norton , Symatec Antivirus v 10.5.1.500
Cheers
Mike
Hi Tanya
As ever our security buffs an FTP !!
Could you mail me the version as a Zip file with the p Missing ( SQLPrompt.zi_) and I'll restore it to its former glory.
That normally gets through our firewall
Bart managed this in the past
Cheers
Mike / comments
Hi Tanya
As ever our security buffs an FTP !!
Could you mail me the version as a Zip file with the p Missing ( SQLPrompt.zi_) and I'll restore it to its former glory.
That normally gets through our...
My breath is baited !!
April 1 doesn't bother me too much as long as its after 12
It will be such a bonus to work in one IDE , I have been working over the weeekend swapping between VS2008 and SSMS , it works but >>>
Mike / comments
My breath is baited !!
April 1 doesn't bother me too much as long as its after 12
It will be such a bonus to work in one IDE , I have been working over the weeekend swapping between VS2008 and SSMS...
Hi Tanya
That sounds greate , I have just renewed my Refactor license so I will be up to speed until this happens
Is there a proposed date for 3.8 Pro ?
If there is to be a Beta please put me on the list , I have Beta'ed other versions in the past as you progressed towards V3 and I find it facinating to see the progression
I think the layout feature in Prompt will be an excellent idea
Cheers
Mike / comments
Hi Tanya
That sounds greate , I have just renewed my Refactor license so I will be up to speed until this happens
Is there a proposed date for 3.8 Pro ?
If there is to be a Beta please put me on th...
Ah Ah
I have a snippet set up that always adds my end when I add begin
I use be to add a BEGIN - newline- END pair
So I wouldn't see a problem like this
Mike / comments
Ah Ah
I have a snippet set up that always adds my end when I add begin
I use be to add a BEGIN - newline- END pair
So I wouldn't see a problem like this
Mike
Isn't this a version thing , I remeber in V2 it happened and I thought it was fixed in V 3
I am running V 3.6 and I can't get it fail , in either /* */ or -- comments
Cheers
Mike / comments
Isn't this a version thing , I remeber in V2 it happened and I thought it was fixed in V 3
I am running V 3.6 and I can't get it fail , in either /* */ or -- comments
Cheers
Mike
Thanks Dave
Guess I should read the help files a bit more , I did actually find after I had posted , on the suggestions list it shows a Function symbol
All that said , as bit of SQL I didn't know about to have it as the default for one of the more common SQL Functions is a bit irritating . I can get around it obvioulsy but to hav ethe standard UPDATE as the default would be preferable
Cheers
Mike / comments
Thanks Dave
Guess I should read the help files a bit more , I did actually find after I had posted , on the suggestions list it shows a Function symbol
All that said , as bit of SQL I didn't know a...
I agree painful , there are a couple of other too , that clash with common alias I use
What do you use most IS or INFORM....
Just rename them out of the way
Edit the <information schema> short cut , make it infs or something
Then create a shotcut is as IS
easy peasy
Mike / comments
I agree painful , there are a couple of other too , that clash with common alias I use
What do you use most IS or INFORM....
Just rename them out of the way
Edit the <information schema> short cut ...