Bill Welbourn <biostats...@yahoo.com> wrote: > I am new to the forum and have a question regarding querying data > from a table, where the table name is random. For example, I have a > database possessing upwards of 41 tables named, TAB10, TAB11,..., > TAB50, and would like to query each table.
Consider instead having a single table with an extra column containing values 10, 11, ... , 50. You'll have no end of trouble with your current design. > Question: Within the C programming environment, is it possible to > prepare a sqlite SELECT query with a random table name as a > variable/parameter? No. Which is precisely why you should reconsider your design. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
