--- In firebird-support@yahoogroups.com, Kjell Rilbe <kjell.rilbe@...> wrote:

>
> raivis83 skriver:
> >
> > --- In firebird-support@yahoogroups.com
> > <mailto:firebird-support%40yahoogroups.com>, "Ann W. Harrison"
> > <aharrison@> wrote:
> > >
> > > On 12/13/2010 6:48 AM, raivis83 wrote:
> > > >
> > > > I have noticed one problem with FOR SELECT statement in pl/sql
> > > >procedure. Correct me if I am wrong but as far as I know ResultSet
> > > >returned by SELECT statement should remain unchanged while looping
> > > > through it. But it isn't.
> > >
> > > Yes, your right, and yes, it's non-standard.
> > >
> > Well, thank you Ann. That was very helpful...
>
> Ann has a long history of being EXTREMELY helpful, but this is a very
> well-known issue amongts Firebird folks, so perhaps she's tired of
> answering it time and again. Also, she did answer your question, actually.
>
> > Can't find anything about it in FAQ's. If there is anything said about
> > it, i must have been using wrong keywords. Language reference also says
> > nothing about this behavior in FOR SELECT section. So i am considering
> > this as a bug, as it is non-standard SQL behavior and there are no
> > references in any kind of material.
>
> Well I don't know where it's documented, if anywhere, but it's an issue
> that has been with Firebird/Interbase since version 0.x. I think it's in
> the roadmap for 3.0 to "fix it", but I'm not sure.
>
> Regards,
> Kjell
> --
> --------------------------------------
> Kjell Rilbe
> DataDIA AB
> E-post: kjell@...
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64
>

I am new to firebird (but not to databases). I did try to search for my problem but my queries resulted in finding nothing about it, so i tried to ask community. There is no reason to be arrogant or what so ever...

Anyway thanks for help Kjell. At-least now i know it's been for ages and that it is a bug and i have to do some workarounds.

Cheers all!