Re: [firebird-support] Get/set context in derived table context

Hi Louis and Walter, thank you very much for your responses. My Spanish is not so good but rudimental thanks to my Latin from school. So I will try the other approaches. Basically I need a join criteria to connect two datasets that have otherwise nothing in common than the order that I am givin

Re: [firebird-support] Get/set context in derived table context

If you can read Spanish, this article shows several methods for having row numbers in the SELECT. https://firebird21.wordpress.com/2013/05/13/numerando-las-filas-de-un-select/ Greetings. Walter. On Thu, Mar 19, 2015 at 5:28 AM, masb...@za-management.com [firebird-support] wrote: > > > Hi all

[firebird-support] Get/set context in derived table context

Hi all, I have the need to implement something like a row number and read the last thread about the autoincrement number which also led me to this FAQ: http://www.firebirdfaq.org/faq343/ http://www.firebirdfaq.org/faq343/ I now tried something like this: select cast(rdb$get_context('USER_TRANSA