You should use sprintf(buf, "CREATE TABLE %s(x double, y double)", tableName);
then use prepare and execute using from that string. ----- Original Message ----- From: "Mike McGonagle" <mjm...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Tuesday, January 13, 2009 3:43 AM Subject: [sqlite] Is this legal SQL? Hello all, I am working on connecting SQLite up to another programming language, and had a question about how SQLite (or SQL in general) would handle this... I want to be able to create some tables dynamically (same structure, different name), and I thought this might work... CREATE TABLE ?1 (x double, y double); And then I would assign '?1' to a string... BUT, it would appear that SQLite does not like this, because when I try to 'prepare' the SQL, it complains about "error near '?1': syntax error"... Is there something that I can do, short of generating the SQL dynamically (ie allow the use of placeholders for the table name)? Thanks, Mike -- Peace may sound simple—one beautiful word— but it requires everything we have, every quality, every strength, every dream, every high ideal. —Yehudi Menuhin (1916–1999), musician _______________________________________________ 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