yes, thank you very much for your help. its work now :)
Downey, Shawn wrote: > > I think you created a column in table1 named "int" of type "id". > > Try: > > CREATE TABLE table2 (id int); > > Then sum() should work. > > Shawn M. Downey > MPR Associates > 10 Maxwell Drive, Suite 204 > Clifton Park, New York 12065 > 518-371-3983 x113 (work) > 860-508-5015 (cell) > > -----Original Message----- > From: LoGi [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 03, 2007 2:13 PM > To: [email protected] > Subject: [sqlite] cant sum rows > > > I create table with this sql: > CREATE TABLE table1 (int id); > > and fill with some randomize values > > I try this sql: > SELECT SUM(id) FROM table1 > > to sum the table rows but its return error no such column: id > > > i use the sqlite from a c++ code > with this function > sqlite3_get_table(); > > > > thanks. > > -- > View this message in context: > http://www.nabble.com/cant-sum-rows-tf2915362.html#a8146664 > Sent from the SQLite mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------ > ----- > To unsubscribe, send email to [EMAIL PROTECTED] > ------------------------------------------------------------------------ > ----- > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/cant-sum-rows-tf2915362.html#a8147569 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
