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 with a variable of the CURSOR data type. It sets the output values for the cursor associated with the variable - it is typically used with a select cursor which SELECT statement has no INTO clause. This method can be called at any stage in the cursor lifecycle. Calling the SetResults() method will overwrite any output values previously specified.
This method accepts a number of parameters which data types, number and order depend on the output cursor values you want to set. Its function is analogous to the INTO clause of the FETCH or FOREACH statements - it specifies the variables into which the output from a SELECT statement associated with the cursor should be performed. It is not required if the statement associated with the cursor has the INTO clause, but if it is used, it will override the variables specified in the SELECT statement. The SetResults() method returns sqlca.sqlcode.
An example method call:
CALL cur_v.SetResults(ret_rec.*)