Thanks for replay. I've tried now with SQLite Command Line Shell, 82 rows as expected (like DB Browser for SQLite). Same query in VB,net 124 rows (???)
.... >----Messaggio originale---- >Da: "Simon Slavin" <[email protected]> >Data: 12/03/2017 20.36 >A: "SQLite mailing list"<[email protected]> >Ogg: Re: [sqlite] Result error in System.Data.SQlite COLLATE NOCASE > > >On 12 Mar 2017, at 7:21pm, [email protected] wrote: > >> I've a simple select statement that have expected result in DB Browser for SQLite (82 rows).Same statement return an error in VB.NET using System.Data. SQLite (164 rows) > >Please try the same SELECT command using the SQLite Command Line Shell: > ><https://www.sqlite.org/cli.html> > >downloadable as part of the 'Precompiled Binaries' for your platform: > >https://www.sqlite.org/download.html > >Simon. >_______________________________________________ >sqlite-users mailing list >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
