John Clegg wrote:
> I have a table Members with 896 rows and a text field "Year2012". It
> contains "Paid" 156 times, "Comp" 13 times and the rest are null (confirmed
> in sqlitebrowser as "empty")
>
> Back in the olden days when this table was in Access, select
> count("Year2013") from Members used to return 169. In LibreOfiice with the
> data stored in embedded HSQL it returns 169. In LibreOffice connecting to
> sqlite3 it returns 896.
sqlite> create table Members(Year2012);
sqlite> insert into Members values('Paid');
sqlite> insert into Members values('Comp');
sqlite> insert into Members values(null);
sqlite> select count(*) from Members;
3
sqlite> select count(Year2012) from Members;
2
sqlite> select count("Year2012") from Members;
2
sqlite> select count('Year2012') from Members;
3
What is the exact query you're using in LibreOffice?
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
