What are the challenges you face when working across database platforms? Take the survey
Options

Cast as Block Snippet bug - bad comma

rldawgrldawg Posts: 35 Bronze 3
edited September 1, 2016 1:02PM in SQL Prompt
The Cast As Block snippet should not have a comma in it.
CAST($SELECTEDTEXT$, AS $CURSOR$)

Corrected:
CAST($SELECTEDTEXT$ AS $CURSOR$)

Comments

  • Options
    Aaron LAaron L Posts: 596 New member
    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.
  • Options
    rldawgrldawg Posts: 35 Bronze 3
    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 :D

    Another good idea for a snippet called trim:
    LTRIM(RTRIM($SELECTEDTEXT$))$CURSOR$
    
Sign In or Register to comment.