Community
    • Login

    Syntax sql is not correct

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    2 Posts 2 Posters 1.7k Views 1 Watching
    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.
    • Оксана КасимоваО Offline
      Оксана Касимова
      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 Offline
        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

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        • First post
          Last post
        The Community of users of the Notepad++ text editor.
        Powered by NodeBB | Contributors