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 free a cursor associated with a CURSOR variable. It can be used with cursors of all types. After the CURSOR variable is freed, you can no longer use it with other methods until you declare the cursor again using the Declare() method.
The Free() method accepts no arguments and frees the cursor associated with the variable. The variable should be used with the Close() method before you can Free() it.
This method returns sqlca.sqlcode which is 0, if the cursor was freed properly and which has a negative value indicating the error number, if something went wrong while executing the method.
An example method call:
CALL cur_v.Free() RETURNING err_code