Problem with Code Folding for SQL Files

Problem with Code Folding for SQL Files

9

    Sep 15, 2007#1

    Hi All,

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

    Code: Select all

    /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 for Loop and Begin statements, they dont work.

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

    6
    NewbieNewbie
    6

      Sep 16, 2007#2

      Hi prashanth7582.

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

      Code: Select all

      /Open Fold Strings = "IF"  "LOOP" "BEGIN" "("
      /Close Fold Strings = ""END IF;" "END LOOP;" "END;" ")"
      ; is an important character if I have code like:

      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.

      Nuf.