Doesn't seem to have created much interest.

Seems like a bug to me.

How do I enter bug into tracker?

regards



Peter Gore

Intel Systems Manager

(ddi) 01277 376433

(swb) 01277 372916

(mob) 07891 911989



________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas
Steinmaurer
Sent: 22 March 2011 09:42
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Read-Only View

> 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.

Right. Me neither. ;-)

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.

--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!




__________________________________________________________________________
Martin McColl Ltd, Ashwells Road, Brentwood, Essex CM15 9ST

This e-mail including any attachments is intended only for the addressee
named above and it may contain confidential or privileged information
If you are not the intended recipient please notify the sender and note
that the contents must not be disclosed to anyone else, no copies can be
taken and all existing copies must be destroyed
Martin McColl Ltd will not be liable for any error in transmission
You should carry out your own virus checks before opening any attachments.
Opinions, conclusions and other information in this message
and attachments that do not relate to the official business
of Martin McColl Ltd are neither given nor endorsed by it


[Non-text portions of this message have been removed]