I need help with define my syntax highliting for SQL.
My problem is:
1.) I dont know, how tu setup keywords for start and end folding. I define keywords "BEGIN IF" in tab "Folder & Default" in start od folding section. And I define keywords "end; end if;" in end of folding section. But, it does not work corectly.
OR
If it is possible, setup folding parameters for existing SQL style (menu: settings -> change style (I dont know how it is exactly in english version, I useing another language))
2.) I want keywords as uppercase. For example:
DECLARE
dStartDate DATE := TO_DATE('01.01.0001','DD.MM.YYYY');
nCountOfRows NUMBER := 0;
CURSOR cGoodUsers IS
SELECT *
FROM t_something
WHERE blabla = 'BLA BLA'
AND status = 1;
BEGIN
FOR rec IN cGoodUsers LOOP
IF rec.column = 1 THEN
nCountOfRows := nCountOfRows + 1;
END IF;
END LOOP;
END;
So, I want setup folding parameters fo:
START END
-------------------------------
1.) IF IF;
2.) LOOP LOOP;
3.) BEGIN END;
& oth...
Is it posiible, setting up language SQL for for this folding conditions? How?
Have somebody some experience with using SQL in notepad++? With executions SQL scripts (SQL, anonymous blocks, procedures etc...) ???
Thanks.
Peter Roznay
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi all.
I need help with define my syntax highliting for SQL.
My problem is:
1.) I dont know, how tu setup keywords for start and end folding. I define keywords "BEGIN IF" in tab "Folder & Default" in start od folding section. And I define keywords "end; end if;" in end of folding section. But, it does not work corectly.
OR
If it is possible, setup folding parameters for existing SQL style (menu: settings -> change style (I dont know how it is exactly in english version, I useing another language))
2.) I want keywords as uppercase. For example:
DECLARE
dStartDate DATE := TO_DATE('01.01.0001','DD.MM.YYYY');
nCountOfRows NUMBER := 0;
CURSOR cGoodUsers IS
SELECT *
FROM t_something
WHERE blabla = 'BLA BLA'
AND status = 1;
BEGIN
FOR rec IN cGoodUsers LOOP
IF rec.column = 1 THEN
nCountOfRows := nCountOfRows + 1;
END IF;
END LOOP;
END;
So, I want setup folding parameters fo:
START END
-------------------------------
1.) IF IF;
2.) LOOP LOOP;
3.) BEGIN END;
& oth...
Is it posiible, setting up language SQL for for this folding conditions? How?
Have somebody some experience with using SQL in notepad++? With executions SQL scripts (SQL, anonymous blocks, procedures etc...) ???
Thanks.
Peter Roznay