Subject Re: [firebird-support] Re: Get/set context in derived table context
Author Louis van Alphen
To be really honest, i would not use this 'fragile hack' in a production system for queries. It is not std SQL and like not guaranteed to work as currently in future versions. I only used it to format a temporary report.

Sent from my iPad

On 19 Mar 2015, at 13:46, "masberg@... [firebird-support]" <> wrote:


What I initially wanted to do with this approach is join two datasets from different and different context variables sources with the row numbers as join criteria, which does not work at all, even when the individual queries show matching row numbers.

BTW I start all processes with a set_context step, to set the desired starting point for both variables to make the row number match.

Kind regards from Hamburg