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

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.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services