Re: [sqlite] curious discovery about geopoly module

You can try some other sqlite wrapper for VBA, for instance vbRichClient ships with 3.24 -- http://www.vbrichclient.com/#/en/Downloads.htm Unfortunately as it's primary target is VB6 the stdcall port of sqlite is compiled to x86 binary only. cheers, -Original Message- From:

Re: [sqlite] [EXTERNAL] unexpected error with "GROUP BY 0"

> By the way, this feature is documented for ORDER BY, but I don't see it for > GROUP BY. It's not standard for GROUP BY e.g. SQL Server does not support it (ORDER BY col indexes are fine there too) At least sqlite does not support the abomination GROUP BY 1 DESC the way MySQL does. cheers,

Re: [sqlite] RIGHT JOIN! still not supported?

You don't need derived tables, just use brackets for explicitly order the execution of JOIN operators like this: SELECT P.PersonName , Pt.PetName , Pa.AccessoryName FROMPersons P LEFT JOIN ( Pets Pt JOINPetAccessories Pa

[sqlite] UPSERT

https://www.sqlite.org/lang_replace.html Time for new compatibility keyword UPSERT? cheers, -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Benoit Mortgat Sent: Wednesday, January 20, 2016 12:00

[sqlite] Is it possible to have query planner use FTS Index for ORDER BY

BY odate" And I now have fast (and sorted) FTS queries again, with no temp B-tree! Thanks. Dave On Thu, Aug 20, 2015 at 11:23 AM, Vladimir Vissoultchev wrote: > Try to rewrite the query like this > > SELECT * FROM main > WHERE rowid IN (SELECT rowid FROM main WHERE

[sqlite] Is it possible to have query planner use FTS Index for ORDER BY

Try to rewrite the query like this SELECT * FROM main WHERE rowid IN (SELECT rowid FROM main WHERE main MATCH 'data') ORDER BY udate cheers, -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of