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 rows consequently from the active set. It can be used with both cursors declared WITH SCROLL and with the sequential cursors. This method moves the cursor to the next row in the active set and retrieves it. It does not accept any arguments.
CALL cur_v.FetchNext()
You can also use this method to verify whether there are no rows left to fetch, because this method returns sqlca.sqlcode which is 0, if there are still rows to fetch and 100, if the NOT FOUND condition occurs, e.g.:
WHILE (cur_v.FetchNext()=0)