Thanks to all. I've found the problem. I was working on two different db... 
;(
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