On 4 Feb 2020, at 7:13pm, Deon Brewis <de...@outlook.com> wrote: > WHERE x IN (?1,?2,?3,?4...,?1000 )
People really do this ? Sheesh. > The alternate to this is to create a virtual table wrapper over the internal > datasets of the app. Which is of course better, but harder. (We need an STL > for SQLite. SqliteTL?). One alternative is to create and populate a temporary table, then use an INNER JOIN or an EXCEPT. You can keep the temporary table around until the app quits. Another alternative is to construct the command as a string. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users