Advertisement
econz

Firebird - Cursores

May 15th, 2014
273
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.34 KB | None | 0 0
  1. EXECUTE block
  2. RETURNS (
  3.    CODCIDADE INTEGER,
  4.    DESCCIDADE VARCHAR(50)
  5. )
  6. AS
  7.  
  8. DECLARE cur cursor FOR (
  9.    SELECT CODCIDADE,DESCCIDADE FROM CIDADE
  10. );
  11.  
  12. BEGIN
  13.   OPEN cur;
  14.  
  15.   while (1=1) do
  16.   BEGIN
  17.     fetch cur INTO :CODCIDADE, :DESCCIDADE;
  18.  
  19.     IF (ROW_COUNT = 0) THEN
  20.       leave;
  21.  
  22.     suspend;
  23.  
  24.   END
  25.  
  26.   close cur;
  27. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement