Hi Alan,
Sorry about the marking the mail to marked as high importance. Let me
tell you a bit a more about my application updates. What I do is
whenever the application receives updates it set some flag parameters
about the downloaded sql script files send by the update server and
sequence in which they should be applied. Now when the application
starts it checks for this flag parameters and if they are available it
will start processing the sql script files.
But the issue we had faced is we have nested stored procedure calls.
Hence in that case Firebird doesn't doesn't also us to run a recreate
script on a dependent procedure. We have to drop all the procedures and
again recreate them. This means the size of the sql script files
increases also at times to update a single procedure we need to drop 20
to 30 procedures and recreated them again. The same is the issue for
updating schema in tables, wherein any column data type change etc needs
to be done and if the that table has any dependency on the procedures
then we have drop all the procedures and recreate them after altering
the table. Please suggest any alternate way.

Regards,
Mahendra Nepali
Desk: +91-22-55044586
Mobile: +919820191887
Email: mahendra.nepali@...

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Alan McDonald
Sent: Tuesday, March 14, 2006 4:48 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Firebird Dependency issue

> Hi,
>
> I have application using Firebird 1.5.2 as the Database. Now the
> application has a feature of receiving application updates and hence
> automatically updating itself without any user intervention. But I
> facing an issue with updating the schema or procedures in my database
> since firebird maintains a dependency list in RDB$DEPENDENCIES system
> table. I want to know that is there any way where I can disable the
> dependencies for the procedures or tables I am altering then apply the
> scripts and then enable or recreate the dependencies again.
>
>
>
> Regards,
>
> Mahendra Nepali

please don't set your emails to high importance.
the answer to this is "not without trashing your database" sooner or
later.
A safer approach is to upgrade your application with a database upgrade
script. Your DB has a table which contains a version number. Each time
the
app starts it tests a match between the application and the db, if
required,
the application runs the upgrade script after first ensuring that it's
the
only connection to the DB... there are other details which we can chat
about
if this sounds interting to you.
Alan




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links









DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.