I’m confused about how to attach a database file to an existing database. I open my main database ok, then to attach the second database, I try to execute the following SQL:
ATTACH DATABASE ‘c:\mydata\my_attach_database.db’ AS ‘attached_db’ Calling “SQLite3_Prepare_v2” on this statement returns SQLITE_OK, but calling “SQLite3_Step” returns SQLITE_NOTADB, and so of course I can’t query the attached database at all. I think I’m missing a concept here. Thanks for any help with this. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users