Igor Tandetnik wrote: > "Robert Latest" <[EMAIL PROTECTED]> > wrote in message > news:[EMAIL PROTECTED] >> $ sqlite3 /cygdrive/d/cl_hist_dat/clhist.sqlite >> SQLite version 3.5.1 >> Enter ".help" for instructions >> sqlite> create view y as select * from tools; >> sqlite> create temporary view z as select * from modules; >> SQL error: unable to open database file > > SQLite can't write to your temp directory. That's why you can create a > regular view, but not a temporary view (which requires opening a temp > database). >
I see this has come up yet again. Richard, have you given any more thought to implementing a better error message for this situation? We discussed this error a while ago in this thread http://thread.gmane.org/gmane.comp.db.sqlite.general/38797/focus=38825 but you never commented on the viability of the changes I suggested. Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users