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. We
issue the hardware and image the machines so all computers are the same,
only the data on them is different.
We're not sure why this error doesn't occur on all boxes. We stepped
through our unit test that covers this code and confirmed that in fact even
in development there is a transaction already in place prior to this
statement and that the value is changing (from 0 to 2).
So besides having a transaction in place, what exatly triggers this
message? We'll move the code for future versions but are trying to identify
why it fails only for this one client machine and if we can get them working
without waiting for the next version of our software.
Thanks,
Sam
-----------------------------------------------------------------
We're Hiring! Seeking passionate Flex, C#, or C++ (RTSP, H264) developer in
the Washington D.C. Contact [EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
