Hi

You just need a to able to run script statements on the customer DB to allow
to DROP the procedure and CREATE the new structure or in some case ALTER
the structure depending on what you want to do.

Anything that can be done with a tool like IBConsole can be done in a script
to your Customer's DB provide you think it through and TEST,TEST, TEST and
then TEST again.

Cheers

Niall R Scott
Systems Engineer
I.S. Support
Cameron Controls
Aberdeen
+44 1224 282440





-----Original Message-----
From: poulposore [mailto:poulposore@...]
Sent: 10 February 2004 16:59
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Modification of the DB structure

Hi,

I'm new to FB, and I have many questions about it (I'll ask for the
others later ;-))

As I understood, all triggers and stored procs are compiled (it's the
one I'm wondering about at the moment):
so, if I've got a "evoluting" DB with modification of the structure
with time, how can I make "automatic" modifications to the customer
structure ? I mean, if I have to change StoredProcs or add new ones
for example, how can I declare it on my customers DB and recompile
them by code, without having each time to give a "new" structure and
copy the data to the one ?

Thanks for informations / suggestions,

David





Yahoo! Groups Links





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail is confidential, may contain proprietary information
of the Cooper Cameron Corporation and its operating Divisions
and may be confidential or privileged.

This e-mail should be read, copied, disseminated and/or used only
by the addressee. If you have received this message in error please
delete it, together with any attachments, from your system.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~