Given your requirement that is the best option and the safest from a
compatibility point of view
Sent from my iPhone
> On 20 Mar 2015, at 13:19, "masb...@za-management.com [firebird-support]"
> wrote:
>
> So, I now used two small SPs with row_count and joined the output. Works fine
> for me.
So, I now used two small SPs with row_count and joined the output. Works fine
for me.
Thanka and kind regards
Christian
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, "masb...@za-management.com [fi
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_contex