You can only bind data elemeents. If you want to chjange table names you have to recompile the SQL (think about it).
Mike McGonagle wrote: > 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 > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users