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 CURSOR variable for both the insert and the select cursors to set the values for the placeholders, if they are present in the SELECT or INSERT statements associated with the cursor.
This method accepts a number of parameters which data types, number and order depend on the placeholders for which they are to supply values. This method can be called either before or after the Open() method for an insert cursor and only before the Open() method for a select cursor. This method returns sqlca.sqlcode.
An example method call:
CALL cur_v.Declare("INSERT INTO customer VALUES (?,?,?,?)")
CALL cur_v.SetParameters("Thomas", "Jones", "35", "m")