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 PREPARED data type to change the output values produced by the prepared statement. This method can be called either for the PREPARED variable, or for the CURSOR variable, if the PREPARED variable was used for this cursor. It is typically used for a prepared SELECT statement which has no INTO clause to specify where the retrieved values should be placed.
This method accepts a number or arguments. Their number, order and data types depend on the values returned by the prepared statement and must match.
You can call the SetResults() method for the PREPARED variable, if this variable is then used independently of any cursor. If you use this variable in the Declare() method to associate the prepared statement with a cursor, you need to execute the SetResults() method for the CURSOR variable declared by this method and not for the PREPARED variable.
An example method call:
CALL prep_v.Prepare("SELECT fname, lname, age FORM customers") -- selects 3 values
CALL prep_v.SetResults(r_fname, r_lname, r_age) -- provides the location for them