SQL syntax highlighter does not respect continued (multiline) strings
Type : Bug
Priority : Low
Gambas version : 3.9.90 (TRUNK)
Product : GUI components
SQL string literals can continue over multiple lines without any special treatment as the string is terminated by the first occurrence of the string delimiter used. For example, the SQL source file may contain:
COMMENT ON TABLE jockey_stats IS 'At the moment this table contains the crosstabulated monthly figures for the jockey over the last 12 months. It is created by an involved query that is run daily.
The column names need changing (desperatley)';
The string is totally delimited by the ' character pair and any CR/LF are ignored.
The SQL syntax highlighter does not respect that convention and treats everything after the "... run daily." as more of the same string.