Hi David Crawshaw,
I don't think that the usage example for SQLiteJDBC (at
http://www.zentus.com/sqlitejdbc/) is correct.
Specifically, the insert syntax should be changed from:
stat.executeUpdate("create table people (name, occupation);");
To:
stat.executeUpdate("create table people values(name, occupation);");
The current syntax fails for me in the sqlite3 commandline client as
well (3.1.3 on OS X). The proposed syntax works, and fits what is
described in the SQLite docs:
http://www.sqlite.org/lang_insert.html
Thanks,
-Marc
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
