To meet your needs, we constantly work to improve Querix products.
This means that Lycia documentation is developing as well.
In case you have found a certain dissonance between the provided information and the actual behavior of Lycia 3 and/or your applications, please, let us know about this via documentation@querix.com so that we can introduce the necessary changes to our documentation.
Thank you for your attention and cooperation.
This method is used to fetch the specified row from the active set regardless of the current cursor position. It can be used only with cursors declared WITH SCROLL. This method moves the cursor to the specified row and retrieves it. The absolute row number depends on the position of the rows located in the active set, e.g. it can depend on the ordering you applied to the SELECT statement for which the cursor was declared.
It accepts one argument which is the row position and is represented by a literal positive integer or an integer expression returning a positive integer. You cannot use a negative integer as the row number. If you try to use a row number below the active set, the NOT FOUND condition will occur.
CALL cur_v.FetchAbsolute(10)