Thread: Cursor

Cursor

From
"Xavier Bermeo"
Date:
hi guys...........
 
This my cursor
 
DECLARE
var varchar(15); 
  cursor1 CURSOR FOR select codigo_uni as codigo
            from recorrido
            where estado='V';
 
BEGIN
 open cursor1;
 
var=cursor1.codigo;
END;
 
It's almost 200 records,
but, I not unknow how read  record for record, I need found one record specific,
 
Excuse me  my english, no write nothing goog, I'm from ecuador.
 
Or explain how, I use the loop, while,  in my function declarated.
Please, more guides....
 
Thanks................