Re: [sqlite] SQL query problem

Ahhh .. yes they do have commas in them. I'll remove the commas and try it again. Thanks, Umesh Dan Baker wrote: - Original Message - From: "Umesh Persad" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, January 16, 2007 10:32 AM Subject: [sql

Re: [sqlite] SQL query problem

- Original Message - From: "Umesh Persad" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, January 16, 2007 10:32 AM Subject: [sqlite] SQL query problem Hi, I was wondering if anyone can help with a problem I have having with SQL. I have a tabl

Re: [sqlite] SQL query problem

Hi Umesh, What is the table structure of your SQLite table? Is it what you want it to be? I am assuming "population" should be integer, as you can't really have fractional people. Did you check your imported data and see if it looks the same as in Excel? Did all the data import? Probably yes

[sqlite] SQL query problem

Hi, I was wondering if anyone can help with a problem I have having with SQL. I have a table 'people' in a Sqlite database with a column 'population'. All I want to do is to add up all the values in this column. When the data is in an Excel file, the column adds up to 8,581,774. I used the