SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
ALTER PROC vs ALTER PROCEDURE

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
ALTER PROC vs ALTER PROCEDURE
Author Message
Mindflux



Joined: 25 May 2013
Posts: 846
Country: United States

Post ALTER PROC vs ALTER PROCEDURE Reply with quote
ALTER PROC (shorthand) does not give the $OBJECT$ list for procedures like alter procedure does. Is this intentional?

http://screencast.com/t/69piTnQzGz7
Thu Jun 06, 2013 1:23 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
SQL Assistant is not currently supporting abbreviated keywords. Only full keywords are supported. Please use ALTER PROCEDURE instead, or type ALT, then press twrice Arrow Down key then Space
Thu Jun 06, 2013 4:18 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 846
Country: United States

Post Reply with quote
SysOp wrote:
SQL Assistant is not currently supporting abbreviated keywords. Only full keywords are supported. Please use ALTER PROCEDURE instead, or type ALT, then press twrice Arrow Down key then Space



Maybe in the future the abbreviations will work as well. :)
Thu Jun 06, 2013 7:40 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
If you don't use the pre-configured code snippet named proc, you can add your own proc snippet and choose "Last char" option for Key Char. The snippet code could be as simple as
Code:
 $OBJECT(proc)$

macro. This will make SQL Assistant automatically display a popup listing all procedures after you type PROC. Note that there is a leading space in the snippet code to separate keyword PROC and the inserted object name.
Thu Jun 06, 2013 9:18 pm 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.