Page 1 of 1

SQL editor, syntax highlight bug if '' was used

PostPosted: Thu Jul 16, 2015 12:46 am
by maqiushi
As described in the attached file.
If we use some kind of too much quotation marks in the SQL query. The SQL syntax highlight not work after ''
If we add a single quotation mark in a comment, it behaves correct.

Looks like a bug here. :)

Is there anyway we can correct this by some preference settings?

Thanks,
Qiushi

Re: SQL editor, syntax highlight bug if '' was used

PostPosted: Mon Jan 11, 2016 12:03 pm
by lopard
Another highlight bug

after this line l_str := REPLACE(l_str,'\','\\') ; the lighlight not work properly. I think the problem is the double /

Re: SQL editor, syntax highlight bug if '' was used

PostPosted: Tue Jan 12, 2016 12:40 pm
by Serge
Actually problem is in the slash followed by ' symbol. In string literals single slash has to be escaped as \\.
It is SQL dialect dependent issue. Some dialects do not require to escape \.
What database/driver do you use?