Hi, it works but does not solve the problem (nor without "DESCENDING"
order).
So things seems to be more complicate :( The only simple solution is
the one suggested by Lele Gaifax, AFAIK.
thanks a lot anyway
Marco Menardi

--- In ib-support@yahoogroups.com, Kubanych Tajmamat uloo
<kubanych@k...> wrote:

> Marco Menardi 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?
> >Thanks
> >Marco Menardi
> >
> >
> SELECT RDB$PROCEDURE_NAME FROM RDB$PROCEDURES
> ORDER BY RDB$PROCEDURE_ID DESCENDING;
>
> this one selects procedure names in order reverce to creation order.
>
> Best regards, Kubanych.