Switch to: V9V8V7V6V5

Differences

This shows you the differences between two versions of the page.

valentina:vcomponents:vsql:reference:compound_stmt:cursors [2017/02/04 06:48]
127.0.0.1 external edit
valentina:vcomponents:vsql:reference:compound_stmt:cursors [2019/04/10 09:38] (current)
ivan
Line 76: Line 76:
    OPEN cur1;     OPEN cur1;
-    FETCH FIRST cur1 INTO a;  
-    LOOP +    BEGIN 
-      BEGIN +        FETCH FIRST cur1 INTO a;  
-        PRINT a; +  
-        FETCH NEXT cur1 INTO a; +        LOOP 
-     EXCEPTION WHEN ERR_CURSOR_WRONG_POSITION THEN +            PRINT a; 
 +            FETCH NEXT cur1 INTO a; 
 +       END LOOP 
 +    EXCEPTION WHEN ERR_CURSOR_WRONG_POSITION THEN
        LEAVE         LEAVE
-      END +    END
-    END LOOP+
END  END 
</code> </code>