On 18 Feb 2018, at 12:44pm, x <tam118...@hotmail.com> wrote: > Suppose I have a query with several parameters on columns that could be > integer, real or text. The values for these parameters are taken from the > result set of another query which is stored in a string array. > > Is there any pitfalls or disadvantages to binding them all as text as opposed > to the more difficult process of checking the column type and converting the > string value to that type? (Assume none of the values are NULL).
Be certain that your column affinities are set correctly in the table definition. Otherwise you risk bad sorting orders and comparisons, because with string values 12 < 5 . Apart from that, I think it should work. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
