> 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 *
> >from CA01P WHERE TYPE01 = 'RQST' ORDER BY IFLG01
> >
> >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

Hi,

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.

Paul.