SQLite INSERTS failing

[NickB]

I've been using POW very happily for a couple of years now.

I've just upgraded my main desktop to FF4 which understandably broke
POW (yes, I'm definitely interested in a version for FF4!).

I decided to run the XULRunner version for a while. This is working
fine for most things: it displays all my pages ok, all SELECT
statements work ok, UPDATE statements work ok and some INSERT
statements work ok.

However, there are a number of INSERT statements which are failing.
The code tries to execute the statement using something like
(simplified for clarity)

sql = "INSERT INTO tblClassHistory ( ClassID, Date, Time, Duration,
CourseTypeID, LevelID, ClassTypeID, Cost, TimeStamp, UserID ) VALUES
( 5, '2011-02-24', 1945, 1.75, 16, NULL, 21, 35, DATETIME('NOW',
'localtime'), 8 )";

var pdb = new pow_DB(dbName);
pdb.Exec(sql);

Absolutely nothing happens and I don't think there's any way of
getting any error message back.

However, when I run *exactly the same sql code* in SQLite Manager
(copying and pasting the sql from where I've displayed it on the web
page) it works perfectly every time.

I thought it might be related to trigger processing but all the
triggers on the tables are UPDATE triggers and removing them all has
not made any difference.

If anyone can shed any light or point me in any direction offering
worthwhile investigation I would be eternally grateful!

Thanks.