Maybe someone can come up with a CTE that works for this... -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Dominique Devienne Gesendet: Donnerstag, 06. Dezember 2018 10:38 An: General Discussion of SQLite Database <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] [EXTERNAL] Re: sqlite3_bind_text() and WHERE x IN (?)
On Thu, Dec 6, 2018 at 8:49 AM Hick Gunter <h...@scigames.at> wrote: > ... which is what SQLite does internally if you provide a list of > literal values inside the parentheses. > Which is IMHO a pity that there's no API to bind such an ephemeral table and 'bind" it. Heck, given how the carray() eponymous vtable works, just have SQLite itself manage that array internally, tying its lifetime to the statement's lifetime, and provide ways to "pushback" typed values in a safe manner, possibly with the existing bind APIs, would achieve the desired result with very little code I suspect. Oh well... --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
