Cast as Block Snippet bug - bad comma

rldawg

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

CAST($SELECTEDTEXT$, AS $CURSOR$)

Corrected:

CAST($SELECTEDTEXT$ AS $CURSOR$)

Aaron L

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.

rldawg

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$