Re: [sqlite] R: Re: Result error in System.Data.SQlite COLLATE NOCASE

[Simon Slavin]

On 13 Mar 2017, at 5:11am, Simon Slavin  wrote:

> The SQLite command line shell tool is written and maintained by the SQLite 
> developer team.  If there’s a but in it they’ll fix it.  However, DB Browser 
> for SQLite is not and faults in it should be reported to whoever 
> wrote/supports it. The fact that you’ve tried the same thing in the command 
> line tool and not got the same error should give them something useful to 
> work with.

Sorry about that.  I got your tools messed up.  Either your VB code is wrong, 
or VB itself is wrong, or System.Data.SQlite is wrong.  I have no idea how to 
figure out which.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R: Re: Result error in System.Data.SQlite COLLATE NOCASE

[Simon Slavin]

On 13 Mar 2017, at 5:04am, andrea-...@libero.it wrote:
> 
> 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 (???)

This throws strong suspicion on where the problem lies.

The SQLite command line shell tool is written and maintained by the SQLite 
developer team.  If there’s a but in it they’ll fix it.  However, DB Browser 
for SQLite is not and faults in it should be reported to whoever wrote/supports 
it.  The fact that you’ve tried the same thing in the command line tool and not 
got the same error should give them something useful to work with.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] R: Re: Result error in System.Data.SQlite COLLATE NOCASE

[andrea-...@libero.it]

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" 
>Data: 12/03/2017 20.36
>A: "SQLite mailing list"
>Ogg: Re: [sqlite] Result error in System.Data.SQlite COLLATE NOCASE
>
>
>On 12 Mar 2017, at 7:21pm, andrea-...@libero.it 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:
>
>
>
>downloadable as part of the 'Precompiled Binaries' for your platform:
>
>https://www.sqlite.org/download.html
>
>Simon.
>___
>sqlite-users mailing list
>sqlite-users@mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users