SQLite and GROUP_CONCAT

supposedly this function was added to Sqlite around 2010(ish)…
but I get “function not found”…
Now I am testing queries in a 3rd party tool before adding them to my Xojo app… and that tool reports SQLite version 3.3.17

any ideas?

even more confusing… SQLite own web page says latest version (this month) is only 3.17 (not 3.3.17)
but other sites say this function was added years ago… in 3.3!

great… Xojo reports version 3.14.1
just how does SQLite number the versions??? is 3.3.17 newer or “older”… I’m thinking WAY older

read those versions like
3.3.17 => 3.03.17
3.14.1 => 3.14.01

3 < 14 so 3.3 is way way older

sigh… yeah came to a similar conclusion… Thanks
the 3rd party tool (SQLiteMan) is from 2007, and it seems it hasn’t been updated since then… I had thought (and wrongfully so) that tools like this “shared” a common install, but I guess each has its own SQLite version baked in…

Anyone have any reccomendations for a FREE replacement SQL tool? I’ve been using this one for years, while not “powerful” its fine for testing SQL queries…

I use SQLite Manager Add-on Extension for Firefox.

Dave

You can use my home-grown SQLite manager:

https://dl.dropboxusercontent.com/u/10747116/InternetUpdates/REALSQLWorkbench/REALSQL%20Workbench.zip

Simon.

[quote=318144:@Simon Berridge]Dave

You can use my home-grown SQLite manager:

https://dl.dropboxusercontent.com/u/10747116/InternetUpdates/REALSQLWorkbench/REALSQL%20Workbench.zip

Simon.[/quote]
Thanks, I’ll take a look