|Subject||Re: [firebird-support] Read-Only View|
> I have created a view which is unexpectedly read-only. It derives from the following SQL.Right. Me neither. ;-)
> 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.
If this is as designed, then either remove the ORDER BY clause in the
view definition and do the ordering when querying the view or add proper
triggers on the view to make the view updateable again.
If this is not as designed, then it should be entered into the tracker
for further investigation.
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server