Community
    • Login

    Syntax sql is not correct

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    2 Posts 2 Posters 1.4k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Оксана КасимоваО
      Оксана Касимова
      last edited by Оксана Касимова

      Hello!
      If in syntax SQL use the value \ in ’ ’ then all further text displayed as STRING.
      Ex.
      sMaskChar varchar2(1) := ’ \ '; (without spaces)
      sMaskStart number;
      sMaskEnd number;
      Why?

      1 Reply Last reply Reply Quote 0
      • cipher-1024C
        cipher-1024
        last edited by

        This appears to be a bug in Scintilla that has been there since the dawn of time. Coincidentally, this was patched a month ago. The bad news is that it can take a long time before NPP gets a new Scintilla engine. If it’s really vexing you, you could install the Poor Man’s T-Sql Formatter plugin. I think that comes with a custom language definition that doesn’t suffer from the same bug. It does some nifty automatic formatting for you too.

        1 Reply Last reply Reply Quote 1
        • First post
          Last post
        The Community of users of the Notepad++ text editor.
        Powered by NodeBB | Contributors