[gnome-db] Gnome-DB SQL Window syntax hi-lighting of keywordsRo



Rodrigo,

I just realized working on the syntax hi-lighting of SQL keywords in the
Gnome-DB SQL Window also provides the basis for the multiple
query/single execution feature.

SELECT *
FROM SOMETABLE
WHERE COL1 = 'BLAH'
AND COL2 = 'UGH' AND COL5 IN ('A','B','C')
AND (COL3 = 'WHOA' OR COL4 = 'WHAT');

-- Comment (Do not Run Me please)
SELECT *
FROM ANOTHERTABLE
WHERE COL2 = 'BLEH';

/*
SELECT 'Commented, so do not run me please'
FROM DUAL;
*/

I assume once that gets done, we can do preferences for it, such as,
keywords "SELECT", "INSERT", "UPDATE", "DELETE" be BOLD BLUE, while
"AND", "OR", "NOT" be NORMAL GREEN.  Comments could be gray italicized. 
Normal text would be black including punctuation.  Single-quoted text
would be normal red.

- Daniel





[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]