How can we help you today?

How can we help you today?

Cast as Block Snippet bug - bad comma

The Cast As Block snippet should not have a comma in it.

CAST($SELECTEDTEXT$, AS $CURSOR$)

Corrected:

CAST($SELECTEDTEXT$ AS $CURSOR$)

rldawg September 01, 2016 10:37

0

Comments

2 comments

Hi,

I'm just having a look into this but I'm not able to find the snippet on my machine and it doesn't look like one that's included with SQL Prompt by default. If it's a custom snippet then you should be able to correct it yourself using the snippet manager.

If I've misunderstood the issue please do let me know!

Thanks,
Aaron.

Aaron L September 01, 2016 10:59

0
Ha! Maybe I created it. Sorry, I need to report the bug to myself and fix it!

Although, it's such a good snippet that I thought it was a prepackage one

Another good idea for a snippet called trim:
```
LTRIM(RTRIM($SELECTEDTEXT$))$CURSOR$
```
rldawg September 01, 2016 13:02

0

Add comment

Please sign in to leave a comment.