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'm using Firebird 2.5
Regards
Peter