Absolutely ;-)

The same mechanism that allows metadata updates of procedures and triggers
in SS should be extended to views. It should also be extended to CS - (in
1.5 anyway) it is not possible to update anything if it has been touched by
a user and they are still logged in.

Regards
Paul

>
> > What's the possibility to allow FB to recreate (alter) a
> view that is
> in use
>
> Hear, hear! I've run in to this many times. Database
> Workbench has a workaround (to dropping all instances and
> then recreating), but it also works only if the view is not in use.
>
> -----Original Message-----
> From: Firebird-Architect@yahoogroups.com
> [mailto:Firebird-Architect@yahoogroups.com] On Behalf Of
> Alexandre Benson Smith
> Sent: Friday, December 07, 2007 7:49 PM
> To: Firebird-Architect@yahoogroups.com
> Subject: [Firebird-Architect] drop/recreate view in use
>
> Guys,
>
> I do my best to do any changes to metadata without users
> connected to the database, but sometimes, I need to do it
> when the database is in use.
>
> Last week I had this scenario, I need to recreate a view, but
> could not do it because there are some user "using it", it's
> was hard to find the person and solve the problem.
>
> What's the possibility to allow FB to recreate (alter) a view
> that is in use (the user who is using keep the old view) the
> newer requests uses the updated view.
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
> Disclaimer: This message (including attachments) is
> confidential and may be privileged. If you have received it
> by mistake please notify the sender by return e-mail and
> delete this message from your system. Any unauthorized use or
> dissemination of this message in whole or in part is strictly
> prohibited. Please note that e-mails are susceptible to
> change. RxStrategies, Inc. shall not be liable for the
> improper or incomplete transmission of the information
> contained in this communication or for any delay in its
> receipt or damage to your system. RxStrategies, Inc. does not
> guarantee that the integrity of this communication has been
> maintained nor that this communication is free from viruses,
> interceptions or interference.
>
>
>
>
>
> Yahoo! Groups Links
>
>
>