Trouble with quotes in comments for mode derived from sql-mode

Trouble with quotes in comments for mode derived from sql-mode

[colin.florendo]

Hello,

I've written a very simple derived mode 'isq' mode which adds c++ style
comments
to sql-mode. The problem am having is unbalanced quotes in comments
mess up string
highlighting. I've seen similar problems in this group but haven't
found a solution.

Here's my derived mode:

(define-derived-mode isq-mode sql-mode "ISQ" "Major mode to edit Sybase
ISQ files."
  (setq indent-tabs-mode nil)
  (setq comment-start "// ")
)

(font-lock-add-keywords 'isq-mode '(("\\(--.*\\|//.*\\)$" (0
'font-lock-comment-face t))))
(add-to-list 'auto-mode-alist '(".isq\\'" . isq-mode))

I'm not sure if this is a shortcoming of sql-mode itself or if I'm
missing something.
Any help would be appreciated.

I'm using gnu emacs 21.1.1 on solaris 2.8

-Colin

Re: Trouble with quotes in comments for mode derived from sql-mode

[albrns]

hiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii

Re: Trouble with quotes in comments for mode derived from sql-mode

[Andreas Röhler]

colin.florendo@sybase.com wrote:

> Hello,
> 
> I've written a very simple derived mode 'isq' mode which adds c++ style
> comments
> to sql-mode. The problem am having is unbalanced quotes in comments
> mess up string
> highlighting. I've seen similar problems in this group but haven't
> found a solution.
> 
> Here's my derived mode:
> 
> (define-derived-mode isq-mode sql-mode "ISQ" "Major mode to edit Sybase
> ISQ files."
>   (setq indent-tabs-mode nil)
>   (setq comment-start "// ")
> )
> 
> (font-lock-add-keywords 'isq-mode '(("\\(--.*\\|//.*\\)$" (0
> 'font-lock-comment-face t))))
> (add-to-list 'auto-mode-alist '(".isq\\'" . isq-mode))
> 
> I'm not sure if this is a shortcoming of sql-mode itself or if I'm
> missing something.
> Any help would be appreciated.
> 
> I'm using gnu emacs 21.1.1 on solaris 2.8
> 
> -Colin

Please load the latest newcomment.el and tell, if the problem persists.

I just digged a little bit into, to adapt some things: not to depend 

on transient-mark-mode, continuation if some key is pressed, fix evolving spaces and so on.

As I didn't work with sql-mode, some questions:

Your comment-start seems the same as in c++-mode. Is the problem also there?

Are you sure you need "// " instead of "--" or other - not so special - chars?

Maybe send some examples with email, so I may look at it.


Andreas Roehler

Re: Trouble with quotes in comments for mode derived from sql-mode

[colin.florendo]

Hi,

The file format I'm using supports both sql "--" and c++ "//" comments.
sql-mode provides the "--" comment, and handles quotes in this comment
style correctly.
I added the "//" comment style through the derived mode, but the c++
comment style does not handle the quotes correctly. I will try the
latest newcomment.el, but I suspect I'll need to modify the syntax
table as suggested by David Hansen below.

Re: Trouble with quotes in comments for mode derived from sql-mode

[Stefan Monnier]

> The file format I'm using supports both sql "--" and c++ "//" comments.
> sql-mode provides the "--" comment, and handles quotes in this comment
> style correctly.
> I added the "//" comment style through the derived mode, but the c++
> comment style does not handle the quotes correctly. I will try the
> latest newcomment.el, but I suspect I'll need to modify the syntax
> table as suggested by David Hansen below.

Of course, you'll have to create a new syntax-table (probably inheriting
from the other one).

But you'll probably also discover at some point that Emacs's syntax-tables
can't correctly handle -- and // at the same time.  I.e. if you tell it
that -- and // both start comments, then Emacs will then mistakenly also
consider -/ and /- to be comment starters :-(

One way out is to use font-lock-syntactic-keywords, but it's not as robust.


        Stefan

Re: Trouble with quotes in comments for mode derived from sql-mode

[Tim X]

"colin.florendo@sybase.com" <colin.florendo@sybase.com> writes:

> Hello,
> 
> I've written a very simple derived mode 'isq' mode which adds c++ style
> comments
> to sql-mode. The problem am having is unbalanced quotes in comments
> mess up string
> highlighting. I've seen similar problems in this group but haven't
> found a solution.
> 
> Here's my derived mode:
> 
> (define-derived-mode isq-mode sql-mode "ISQ" "Major mode to edit Sybase
> ISQ files."
>   (setq indent-tabs-mode nil)
>   (setq comment-start "// ")
> )
> 
> (font-lock-add-keywords 'isq-mode '(("\\(--.*\\|//.*\\)$" (0
> 'font-lock-comment-face t))))
> (add-to-list 'auto-mode-alist '(".isq\\'" . isq-mode))
> 
> I'm not sure if this is a shortcoming of sql-mode itself or if I'm
> missing something.
> Any help would be appreciated.
> 
> I'm using gnu emacs 21.1.1 on solaris 2.8
> 

This may not be of any use, but I use to use plsql-mode
(http://www.emacswiki.org/) which is also derived from sql mode. The
point is that plsql mode uses comments which start with -- (not that
much differenct from //). So, maybe this might give you some
hints. Therre were some bugs in plsql-mode which I contacted the
maintainer about (including patches), but never got a reply. However,
aside from the bugs, it worked quite will and I used it a lot back
when I was working with Oracle on a daily basis.



Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!

Re: Trouble with quotes in comments for mode derived from sql-mode

[David Hansen]

On 19 Jan 2006 06:20:41 -0800 colin wrote:

> Hello,
>
> I've written a very simple derived mode 'isq' mode which
> adds c++ style comments to sql-mode. The problem am having
> is unbalanced quotes in comments mess up string
> highlighting. I've seen similar problems in this group but
> haven't found a solution.
>
> Here's my derived mode:
>
> (define-derived-mode isq-mode sql-mode "ISQ" "Major mode to edit Sybase
> ISQ files."
>   (setq indent-tabs-mode nil)
>   (setq comment-start "// ")
> )

You have to modify the syntax table otherwise the syntax
parser will treat quotes within "comments" as the start of a
string.

> (font-lock-add-keywords 'isq-mode '(("\\(--.*\\|//.*\\)$" (0
> 'font-lock-comment-face t))))

And then you don't need this anymore as the syntax pass of
font-lock already highlights strings and comments.

David