> -----Original Message-----
> From: Marco Menardi <mmenaz@...> [mailto:mmenaz@...]
> Sent: Tuesday, January 21, 2003 11:42 AM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Re: Metadata SP order extraction problem
>
>

[snip]

> Anyway, I've tested the extraction with FB 1.0 and 1.02, same result.
> The guys at EMS (IB_Manager) told me about a new algorithm to extract
> metadata in the correct order, but I'm waiting too long for the next
> release, and I do need this.
> There should be a "natural order" for the metadata, that maybe IB_SQL
> and IB_Manager overrides, or, if not, I will ask Jason about a solution :)
> thanks
> Marco Menardi
>

Marco,
The different "managers" out there all have strenghs and weaknesses, so I
use different ones for different things. I use the free (read "slightly
crippled" )
version of IBExpert for my metadata extractions because it correctly handles
this problem by creating empty procedures before tables, triggers, etc are
created,
then at the bottom of the script does an alter to put the actual sp code
back in.
Thus, the cross-references never cause a problem.

HTH,
Brian