Besides that, shouldn't it be cursor.execute "insert into ""default"" (rowname) values('1');"
I would expect that the execute command is expecting a string containing the SQL to execute. ----- Original Message ----- From: "Petite Abeille" <petite.abei...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Tuesday, December 20, 2011 2:40:50 PM Subject: Re: [sqlite] insert error On Dec 20, 2011, at 8:34 PM, jim-on-linux wrote: > cursor.execute insert into default (rowname) values ( '1' ) ; 'default' is a keyword: http://www.sqlite.org/lang_keywords.html If you insist on that name, double quote it. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users