Hi. I'm using this wonderful library with no problem till today. I've this simple query
SELECT DISTINCT COM_STRADARIO.ID_STRADARIO, COM_STRADARIO.TIPO_VIA, COM_STRADARIO.NOME_VIA FROM COM_STRADARIO inner join INT_CONDOMINI on COM_STRADARIO.ID_STRADARIO = INT_CONDOMINI.ID_STRADARIO ORDER BY NOME_VIA It works fine if I run with SQLiteManager for Firefox, but with System.Data. Sqlite no rows are returned. Can you help me? I use 1.0.65.0 with 2.0.50727 runtime and SQLite.Interop.065.dll I use the dll in compactframewor 3.5, windows mobile 6.5.3 Thanks Alessandro _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users