Hi all, I can't seem to use fully qualified table names (dbName.tableName).
For instance, I create a database file inventory.db, and create a table food. "SELECT * FROM inventory.food" does not work, nor does "SELECT * FROM inventory.db.food" bc it says "no such table ...". Since there is no CREATE DATABASE statement, I'm wondering what qualifies as a database in sqlite. I expect it to be the name of the database file. This seems like a simple question, and I bet I'm just being a bonehead. Please help me out. Thanks, jb _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
