On Sun, Sep 27, 2015 at 1:37 PM, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote:
> > > The only way to know how many contexts a stored procedure has is looking > at the source code and counting handly them? > > The limit on contexts is per statement, not for an entire stored procedure, trigger, or whatever. A statement is a SELECT, INSERT, DELETE, or UPDATE. Each table reference is a context. So, for example, a reflexive join has more than one context for the same table. An update with lots of subselects has contexts for each part of the subselect. A statement that references a view has contexts for every table reference in the view. So, don't worry about the total number of contexts in a stored procedure, but do worry about the use of complex views in apparently simple statements. Good luck, Ann > >> >> > > > > ------------------------------ >
