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!
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…