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.