On 4 Feb 2020, at 7:13pm, Deon Brewis <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
