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
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
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
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
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] =
On 12 Mar 2017, at 2:34am, ROCHAK GUPTA wrote:
> I am using sqlite as library in multi-threaded environment where multiple
> applications use sqlite queries to perform get/set operations on attributes
> available in sqlite db tables. Intermittently i am seeing
>
> If you use sqlite3_bind_blob on insert and select, it will successfully
> find the
> test row. Only mixing sqlite3_bind_blob, and sqlite3_bind_text causes these
> mysterious failures. Does sqlite3_bind_text... encode it to UTF-16 or
> something?
>
> This is still a (moderately) huge problem
In my endless obsession with premature optimization, I've been using
sqlite3_bind_blob, whenever I know the length of what I'm inserting, even if
it's text or whatnot. It exhibits some very strange properties though, which I
can't imagine is anything other than a bug. Here's my test case:
Darn it! Sorry! I forgot to reset my prepared select statement. My whole example
was screwed up. The actual behavior is at least sensible-ish, but still not
quite right.
If you use sqlite3_bind_blob on insert and select, it will successfully find the
test row. Only mixing sqlite3_bind_blob, and
Hello,
I am using sqlite as library in multi-threaded environment where multiple
applications use sqlite queries to perform get/set operations on attributes
available in sqlite db tables. Intermittently i am seeing applications
crashing when get operation is performed which intern call
10 matches
Mail list logo