Problem with Code Folding for SQL Files

[prashanth7582]

Hi All,

I am using the bBelow syntax in my wordfile.txt for code folding my SQL Files..

/Open Fold Strings = "ELSIF" "IF" "IF" "ELSE" "IF" "LOOP" "BEGIN"
/Close Fold Strings = "ELSE" "ELSIF" "ELSE" "END IF" "END IF" "END LOOP" "END"

I want the Code folding between IF and End if, If and Elsif, If and Else if it exists.

They work for If statements but forLoop and Begin Statements, they dont work.

Please let me know what changes I need to do in above syntax.

[Nufacik]

Hi prashanth7582.

I using UE for programming in PL/SQL.
Main reason is code folding. I have setup like this

/Open Fold Strings = "IF" "LOOP" "BEGIN" "("
/Close Fold Strings = ""END IF;" "END LOOP;" "END;" ")"

; is important letter... if I have code:

Code: Select all

BEGIN
  FOR record IN cursor LOOP
    --- working area ---
    IF something THEN
      calling function
    END IF;
  END LOOP;

In my programming this is exactly what I need.
I have created tool for run scripts on DB, select's, procedures - everything

If you have some questions, send me email.

Nuf.