Subject Re: Too many Contexts ... Maximum allowed is 127.
Author m_brahim11
Thanks for the answer.
But why these restrictions : 127 in FB 1 and 255 in FB 2 ?

--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:
>
> On 1/27/2011 9:23 AM, m_brahim11 wrote:
> >
> > Is it possible to know by SQL in FB 2.5 what is the number of contexts
> > used by a specific SP in order to prevent the
> > Too many Contexts of Relation/Procedure/Views message ?
> > I mean, the totally dependencies for a specfic SP.
> >
>
> Not by SQL. The restriction applies to a single query, not the
> whole stored procedure, so you'll need to look at each query
> individually and each view in each query and each view in each
> view...
>
> Good luck,
>
> Ann
>