Hello! We are using SQLite to collect process data so that it can be displayed on a graph. While a user is looking at the graph, the database is locked and no new data can be added to the table. If a user opens a graph and walks away for two hours, the database containing data for that graph will be missing two hours' worth of data.
I do not care if data is updated while the graph is open. If the user wants to refresh data, he can click on a refresh button. All I need is a snapshot of the data when the database is first opened. The documentation says that sqlite3_open_v2() has four arguments, and one argument consists of a set of flags, and one possible flag is SQLITE_OPEN_READONLY. I would expect that that would leave the database able to accept updates from other sources. However, my application is written in C++ using MS Visual Studio 6, and it uses Unicode. For that reason, I don't use sqlite3_open(). I use sqlite3_open16(). This allows me to use the Unicode-based file name that I have. The documentation doesn't list a sqlite3_open16_v2() function. Is there a way to allow external writes to my database while it's open while still using sqlite3_open16()? Or do I have to cram my file name into a set of 8-bit characters and use sqlite3_open_v2()? I am trying to make sure I close my database after I'm done with it, but I haven't yet succeeded, and if I can open it correctly the time that I close it will no longer matter. Thank you very much. RobR _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users