The current version of SQLite itself is 3.27.2, Version 3.11.1 would be from 2016 and does not have window functions (introduced in Version 3.25)
Please check which sqlite binding product you are using and see if it has a support page. If a query works from the sqlite shell but not from the program, it is not a problem with SQLite but with the binding/wrapper/whatever you are using. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von desarrollo ribisoft Gesendet: Mittwoch, 06. März 2019 16:28 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] Integration with las version of SQLite Good morning, I have a project in c# which I integrate with SQLite and I have very good performance at all, I've had no troubles, but yesterday I updated to last version of SQLite 3.11.1 and began to use the ROW_NUMBER() function, and running the query in the interface of DB Lite I had no troubles, but when I run that same query in c# I'm getting errors because it doesn´t recognise that function, I'd like to know if you know how to update the connection or integration between c# and this last version of SQLite, thanks in advanced. -- Muchas Gracias Cordialmente: _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
