On 8/15/18, Mr Max <bob.maxw...@ntlworld.com> wrote: > When running this with the ODBC driver it fails to return all the > appropriate record in the range. I tried the exact same query in a DB > Browser for Sqlite and it recovers 127 records only.
What answer do you get when you run your query using the officially-supported "sqlite3.exe" command-line tool available from (https://www.sqlite.org/download.html)? The "DB Browser for SQLite" is a third-party tool, about which I know very little. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users