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" <[email protected]>
To: "General Discussion of SQLite Database" <[email protected]>
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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
