"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).

Igor Tandetnik 



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to