On Jul 17, 2008, at 12:11 PM, Samuel Neff wrote: > We're inconsistently getting this error: > > PRAGMA temp_store = MEMORY > ---> System.Data.SQLite.SQLiteException: SQLite error > temporary storage cannot be changed from within a transaction > > We now realize that we are in fact issuing the PRAGMA inside a > transaction, > but the weird thing is it works without error on a half dozen > development > boxes, half dozen test boxes, and a few dozen or so client computers > that > have this version. Only one client computer fails with this error.
The error only occurs if the temp_store value really is trying to change. If the new temp_store value is the same as the old, no error is generated. Are you sure you had not already issued the PRAGMA once before, prior to starting the transaction? D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users