On 14 Nov 2011, at 1:52pm, Matt Young wrote: > SQL needs a create schema, then the statement can be prepared against a > know schema, and swap out the table pointer at run time. The problem of > one great sql procedure that works on many different table of the same > format. > > I have a work around.
Solutions: A) Merge the tables which all have the same schema. Make the table name a column. B) Prepare the whole command as text, rather than binding variables. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
