[Firebird-devel] Re: Cursor returned type variables

[Alexander K. <as...@id...>]

>declare c cursor for (select ..);
>declare variable c_type cursor c;
>begin
>  open c;
>  while (1 = 1) do begin
>    fetch c into c_type;
>    if (c_type%field1 = 'some_value') then ...
>  end
>end
Or, better yet, as I have proposed a few weeks ago,
declare c cursor;
begin
   for select ... as cursor c do begin
     if (c.field1 = 'some_value') then ...
end

>That would make it easy to use cursors which returns many 
>fields. It
>wouldn't be necessary to declare all those variables one 
>by one.
And not only that ;)
---
Professional hosting for everyone - http://www.host.ru