Hi, I'm using SQLite from a scripting language (Rebol). There I have a CONNECT/CREATE function that calls sqlite3_open to open and if necessary create a database file.
My situation is now that I have an application that needs to create several database files. Hence I need to call sqlite3_open serveral times. Each time I get back a new database handle. I didn't find any good information about dealing with multiple database handles beside that for each one I need to call sqlite3_close. Some questions: 1. If I open database A and B and get back handleA and handleB, can I call sqlite3* function for database A using handleB? 2. Could I close handleA after I got handleB and still use all open database files and tables or do I have to keep all database handles around? 3. What's exactly the role of a database handle when working with several database files and ATTACHED databases? To me it looks a bit fuzzy. -- View this message in context: http://www.nabble.com/sqlite3_open---ATTACH---creating-databases---multiple-database-handles-tp20815131p20815131.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users