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

2017-03-12 Thread Simon Slavin
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

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

2017-03-12 Thread andrea-...@libero.it
Hello everybody, 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) Statement is: SELECT * FROM [tblDictionary] INNER JOIN [tblLanguage] ON [tblDictionary].[idLanguage] =