SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
sql syntax completion code

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
sql syntax completion code
Author Message
tzahik1



Joined: 15 Jul 2008
Posts: 4
Country: Israel

Post sql syntax completion code Reply with quote
Hi.
i trying to find if sql assistant can complete the basic TSQL keywords
like SELECT , BEGIN TRANSACTION and all the basic TSQL/SQL , and not only the objects defined in "list item" in options.
is there a way?
(i know in redgate sql prompt it give full intellisense of ALL keywords - not only the objects)

thanks.

Zahi.
Tue Jul 15, 2008 1:24 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
There is currently no such feature. If you need assistance with keywords, you likely need a different kind of tool, something like graphical drag-and-drop query builder which will paste all keywords for you.

Regards, SysOp
Tue Jul 15, 2008 1:33 pm View user's profile Send private message
tzahik1



Joined: 15 Jul 2008
Posts: 4
Country: Israel

Post Reply with quote
thanks for your quick reply.

do you inted to add this feature in the future?
Tue Jul 15, 2008 2:52 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Maybe. I don't know for sure, but frankly I think that in any case that would be a very low priority enhancement because the impact on developer productivity is near zero, keywords are short and time taken to select them from a suggestion list is typically much longer then to finish typing them, not to mention that such selection requires similar number of keystrokes.

And secondary because many keywords are currently used to display history based suggestions, for example, when you type SEL you get a list of recent or most commonly used SELECT quires so that you can quickly pick and modify one of them rather then type the entire thing in full. This feature alone provides sometimes very significant time savings. If you just started using SQL Assistant, you may not be able to see that feature for a little while, until the historical queries cache is filled with some data.
Tue Jul 15, 2008 3:31 pm View user's profile Send private message
tzahik1



Joined: 15 Jul 2008
Posts: 4
Country: Israel

Post Reply with quote
yes, i saw the history.
but for spelling is very good to have that feature (like TRANSACTION or other big words)
and as you say for choosing the right keyword from a list - its time saving.
(you did all this hard work to all the objects , functions etc, so the basic keywords (you even have built in functions - so why not the basic ones?)
:-)
Tue Jul 15, 2008 3:54 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
If you wish, you can add keywords to the Custom Assistance group of options and have them displayed when you press Ctrl+Space in any place

Open SQL Assistant options -> click DB Options tab -> click SQL Server assistance type on the left -> on the right expand Custom Assistance options group -> scroll down and find line [@@] -> before that line insert needed keywords, one keyword or keyword set per line -> Click Ok or Apply button to save changes.


Now if you restart target editors, in case they were running, you can start using new keyword suggestions. For example, if added the following lines to the Custom Assistance as described above

SELECT
SELECT * FROM
BEGIN TRANSACTION
BEGIN TRAN
ROLLBACK TRANSACTION
ROLLBACK TRAN
ROLLBACK


in the target editor press Ctrl+Space, type se, you should see SELECT and SELECT * FROM suggested in the popup list. Similarly if you type roll you are going to get 3 suggestions for ROLLBACK.
Tue Jul 15, 2008 4:41 pm View user's profile Send private message
tzahik1



Joined: 15 Jul 2008
Posts: 4
Country: Israel

Post Reply with quote
Thanx.

:-)
Wed Jul 16, 2008 4:57 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.