Hi, I am wondering if the sqlite API could be changed to accommodate array parameters, for example when using the literal `@?`.
This would be handy when specifying `INSERT INTO t(@?) VALUES(@?)` or `SELECT * FROM t WHERE v IN (@?)`. Apart from the ease of use benefit, I think this will help with prepared statement reuse. I'm not sure what the bind interface would look like, since each array entry can have a different type. How about binding a value on the array parameter index pushes onto the parameter array value? So to populate the array value, call the bind functions on the same index, in array order. It would also be nice to have a way to detect if the API supports array parameters. How to do that, performing a query and see it fail, or is there some function to request capabilities? The literals could accommodate naming and numbering parameters with `@:AAA` and `@?NNN` syntaxes. Wout. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users