Hi All, I'm writing a Tcl-based application that manages a pool of separate SQLite database files. The application is multi-User, but it requires each User to "check out" a specific database in order to access it, so a single database is only ever accessed by a single User....
That is, until now... ;^) I have one specific situation where I need to retrieve a single BLOB record from another database in the pool (not the one that's currently checked out). In fact, this other database could be checked out to (and be in use by) another individual when I need the record. So, my question. Is it safe for me to blindly open the other database and grab the record I need? This would only be a SELECT operation, and would never actually write anything to the other database file. If that's deemed unsafe, could I simply make a temporary copy of the other database (literally by copying the db file itself), grab the record from there, and remove the copy? In case it's important, the application will be running on WinXP... Thanks for any advice. Jeff _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
