--- In ib-support@yahoogroups.com, Lester Caine <lester@l...> wrote:

> > Hi, I've always extracted metadata (with IB_Manager or IB_SQL),
> > modified and rebuild the database.
> > Now that I've add other more SP in my database, I can't rebuild
> > because the order in wich metatata is extracted makes a SP being
> > created before another SP that it calls (i.e. A calls B, and A is
> > created before B, so it does not found the B reference).
> > If I rearrange the SP order and build the database, next time I
> > extract and rebuild I have the same problem.
> > Is there a way to extract the SP in "creation" order? How can I avoid
> > this?
>
> Given that we all fully document our development process -
> don't we - then you should be adding the extra stuff to the
> latest clean script, and not extracting from the database
> each time <g>

The problem comes from some FB/IB "limit", i.e. you can't do certain
operation in a database (i.e. add a default to a column without
domain, or change primari index that are used in foreign contraints),
so I have to extract the script and do it by hand.
On the other hand, IB_Manager makes a lot of task much more easy that
it would be manually editing the script, so I need "both", i.e. work
with IB_manager the most I can, and rebuild to do some "dirty" tasks ;)

> Since we all know that does not happen, what does control
> the order that the information is extracted, and can that
> actually be adjusted - so we can get Jason to update IB_SQL.
>

That's the question I need an answer for :)
regards
Marco Menardi