Hi

What are you doing when developer database is different from end user client
database from point of dependencies ??? Generated script from developer
database is not sure to work properly on end user database!?



Regards

Paul



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Milan Babuskov
Sent: Thursday, June 15, 2006 10:17 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Disconnect dependencies



--- In firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com> , <myles@...> wrote:

> For example, I have a
> column in a table that is a VARCHAR(500) but I need to make it
> larger to VARCHAR(1000).
>
> But I have a number of stored procedures that refer to this column.

Open table's property page in FlameRobin and click on Generate rebuild
script.

It will generate a script that first drops all dependencies (check
constraints, foreign keys by other tables, etc.), then all dependent
objects (views, procedures, triggers), and then you'll see a line

/***** DROPPING COMPLETE ****/

underneath that is the part of script that recreates everything that
was dropped.

So, execute the frist part (up to DROPPING COMPLETE), then do the
changes in table's structure, and then run the second part (after
DROPPPING COMPLETE) to rebuild all the dependencies.

This feature is available since FlameRobin 0.7.2.

</M>





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