Lukas Fellechner wrote: > > I tried using the WinRT builds of sqlite. But I find there are problems > when using transactions. While my table creation and insert statements work > fine, all transacted "update" statements are failing with result > "CannotOpen", error message is "unable to open database file". This even > happens when the connection is already open and I have already inserted > some lines into the DB. So the file is definately opened and write locked > for SQLite. >
Setting the sqlite3_temp_directory to the value contained in the "Windows.Storage.ApplicationData.Current.TemporaryFolder.Path" property should clear the issue. This can be done immediately after opening the connection using PRAGMA temp_store_directory command on the newly opened database connection. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
