Hi,
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.
Question: Within the C programming environment, is it possible to prepare
a sqlite SELECT query with a random table name as a variable/parameter?
For example, I have been unsuccessful using the following code:
sqlite3_prepare_v2(db, "select * from ?", -1, &stmt, 0);
sqlite3_bind_text(stmt, 1, "TAB10", -1 , 0);
sqlite3_step(stmt);
...
Any help is greatly appreciated.
Thanks,
Bill
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
