On 26/08/10 12:20, Pavel Ivanov wrote: > Yes, "validation" happens only at the time of execution. So you are > apparently doing something wrong and you better show your code. >
easiest is to provide links to a copy. I've added a .txt extension to all the files to stop them being executed by the web server The key php file I am talking about is this one http://www.chandlerfamily.org.uk/sites/default/files/files/snippets/updatedefcur.php.txt It is trying to update the view (dfxaction) which provides transaction amounts in the default currency because the default currency is changing.. You will see it requires db.inc which is here http://www.chandlerfamily.org.uk/sites/default/files/files/snippets/db.inc.txt This initializes the global variable $db by opening the sqlite database. The whole database schema is loaded on initial initialization by reading this file The dfxaction view is created almost at the end of this file. http://www.chandlerfamily.org.uk/sites/default/files/files/snippets/database.sql.txt (someone asked further down the thread whether the view really exists. Yes it does and its not temporary). -- Alan Chandler http://www.chandlerfamily.org.uk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
