Suggestion List from Snippets

• 
  Hi Mike,
  
  I've just tried typing ssf with various completion keys in SQL Prompt 4 and SQL Prompt 5, and I haven't yet see any differences in behaviour. You're correct that after completing the ssf snippet, you have to type ctrl-space to show the list of tables.
  
  If you've managed to get the list of tables to appear immediately after completing the snippet, could you let me know which completion keys you have set up, and what keystrokes you are using?
  
  Thanks,
  Paul

  Paul Stephenson December 20, 2010 05:30

  - 0 +
• 
  The supplied snippet is "SELECT * FROM".
  
  I modified this to include a space at the end, thus "SELECT * FROM ", thinking it might make my life easier.
  
  Reading this post, I now realise that whereas, before, my tapping space would trigger the list of table names, now, with the space included in the snippet, I have to additionally Ctrl-space to make the same list appear.
  
  Perhaps you're seeing something like this?
  
  Hope I make sense!

  dmckinney February 22, 2011 08:54

  - 0 +
• 
  I have noticed the same thing, I have a space after the FROM in my SSF snippet as well, and then have to hit ctrl-space to get suggestions. It would be nice if it brought the list up automatically.
  
  I'm thinking maybe an additional placeholder like $SUGGEST$ to let it know that we want the suggestions to come up at that point. ($SUGGEST$ would probably need to position the cursor as well.)

  MikeyC February 22, 2011 11:51

  - 0 +
• 
  I have added the $SUGGEST$ placeholder feature request to the uservoice site, so if you like the idea you should go vote for it: http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions/suggestions/1519439-add-suggest-placeholder-in-snippets

  MikeyC February 22, 2011 11:59

  - 0 +

Add comment

Please sign in to leave a comment.