Thank you very much Dmitry for your answer, it is more clear now, however I still have some doubts.
According to Vlad Khorsun, each INSERT, UPDATE or DELETE has 2 contexts, cause of the variables NEW and OLD of the triggers. Is that not true? The only way to know how many contexts a stored procedure has is looking at the source code and counting handly them? Greetings. Walter. On Sun, Sep 27, 2015 at 12:16 PM, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > 26.09.2015 05:59, 'Walter R. Ojeda Valiente' wrote: > > > > Is there some SELECT that can give me the number of context a stored > > procedure has? > > No, it's impossible. > > > Other question: > > > > Which are the comands that count as context? > > > > I know: INSERT, UPDATE, DELETE, SELECT, UNION. Is there some more, JOIN > > or FETCH maybe? > > It's not about commands, context is a table reference. A trivial INSERT > statement has one context, join of three tables has three contexts, etc. > Additionally, every UNION and GROUP BY produce one more context. > > > And the last question: > > > > That number of 255, will be incremented in Firebird 3? > > No. > > Dmitry > > >
