| Subject | Re: FOR SELECT resultset changed during update statement |
|---|---|
| Author | raivis83 |
| Post date | 2010-12-14T07:26:26Z |
--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:
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, thank you Ann. That was very helpful...
> 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.
>
>
> Good luck,
>
> Ann
>
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.