New features added to SQL Prompt Watch now.

$SELECTEDTEXT$ only expands once

eklein@ahd.com[email protected] Posts: 16 Bronze 2
edited August 25, 2015 10:38AM in SQL Prompt
Using 7.0.0.40

setup a new snippet


sum ( $SELECTEDTEXT$ ) as tot_$SELECTEDTEXT$

when it expands the $SELECTEDTEXT$ only expands the second time it appears

Example result

sum ( $SELECTEDTEXT$ ) as tot_Current_db

Comments

  • Aaron LAaron L Posts: 596 New member
    Thanks for your post,

    The current implementation of $SELECTEDTEXT$ only expands once per a line, I think your snippet is a good example of why we would want to expand it more than this though! I'll have a look into removing this restriction and should have a new build for you later today.

    Thanks,
    Aaron.
  • Aaron LAaron L Posts: 596 New member
    We've just released a new build of Prompt (7.0.0.41) which should allow you to use multiple $SELECTEDTEXT$ placeholders on a single line. You can download the latest build from our website or through the check for updates dialog inside Prompt. Please let me know if this works as you'd expect.

    Thanks,
    Aaron.
  • I've tried it and it now works as I had anticipated.

    Thanks for you quick response
Sign In or Register to comment.