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