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