Hi Simon, Thanks for the quick reply.
Without the INSERT call, my test code runs through without crashing. Attempting the INSERT call in the shell tool crashes it too. Following your advice, the output of the .schema command looks dodgy: CREATE TABLE test_table (name TEXT DEFAULT ('joe'), interest TEXT DEFAULT (?1)); I'm an SQLite newbie, though, so maybe that's right. Or perhaps bound parameters aren't 'resolved' in a "CREATE TABLE" statement? Thanks again, Nathaniel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users