Re: Please increase the default for SQLITE_MAX_VARIABLE_NUMBER
Simon Slavin <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
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