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