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
On So, 2012-09-16 at 17:17 +0100, 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
Hi John,
Funny seeing you here on the SQLite forum.
Are these by any chance the ISUG members?
Doing a count without a WHERE clause is always likely to give different results
with the various SQL implications as far as I know.
Why not add a WHERE?
RBS
On Sun, Sep 16, 2012 at 5:17 PM, John Clegg
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
On 16-09-2012 18:21, Marcus Ilgner wrote:
On So, 2012-09-16 at 17:17 +0100, 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
The Year2012 field is not null, it is an empty string (that is, '', which is
not NULL).
---
() ascii ribbon campaign against html e-mail
/\ www.asciiribbon.org
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of John
On 9/16/2012 9:17 AM, 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
PS Note that it is count(X) and not count(X)
Count(X) and Count(X) are identical if X is a column in the table (or join)
from which you are counting, and X does not contain embeded spaces, special
characters, or other inanities. count(*) counts rows, and count('X') or
count(1) [or any
Browser IA wrote:
Does System.Data.SQLite support Visual Studio 2012 Ultimate RTM?
The latest trunk code now supports Visual Studio 2012 and the .NET Framework
4.5.
The changes required to make this work were fairly extensive. This support
will
be present in the next release, 1.0.83.0,
