Subject RE: [firebird-support] Read-Only View
Author Paul Lopez
> At 10:15 PM 22/03/2011, gorepj wrote:
> >I have created a view which is unexpectedly read-only. It derives from the
> following SQL.
> >
> >select *
> >
> >This View is non-updatable
> >
> >If I remove the ORDER BY Clause it becomes updatable. I can't see in the
> documentation that having an ORDER BY clause will make a view read-only.
> I don't know why it would be updatable, as an ordered set is not a natural
> set.
> ORDER BY in a view is quite a recent addition, too. I wondered if it was an
> accident! There doesn't seem to be much use for it.
> ./hb

I wonder if it has something to do with needing to order by a unique or primary key, or provide order by fields that identify records uniquely?

Is the IFLG01 field unique? Could you add more fields to order by in order to make the order by unique?

Just a theory... I haven't tried it.