Integrity is ok.
I've downloaded the installation package from http://sqlite.phxsoftware.com/
I think the SQLite version is 3.6.16
Ale

-----Messaggio originale----- 
From: Simon Slavin
Sent: Monday, June 20, 2011 11:12 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Problem with System.Data.SQLite and join II


On 20 Jun 2011, at 10:05pm, Alessandro Caliaro wrote:

> Your test works fine. I have returned all lines...
> Which could be the problem?

Then the data is actually there.  Run an integrity check in the command-line
shell:

http://www.sqlite.org/pragma.html#pragma_integrity_check

If this says there is no file corruption, then the fault is in
System.Data.Sqlite or in your programming.  See if you can check which
version of SQLite your System.Data.Sqlite has built in (I don't know how to
do this).

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

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to