[sqlite] trigger error: can't find main.new

Hi, I am having trouble getting a SQLite trigger to function properly. The error I recieve is something like "SQL Error: table not found: main.new" when the trigger fires. Here is the background for my problem: I am trying to create a basic task list in SQLite. I have created a table called

Re: [sqlite] Can a trigger update more than one column?

> Both insert_ts and last_upd_ts get updated when I try this. > What version of SQLite are you using? What platform? What > language binding? I'm running sqlite 3.2.2 on Win XP, and I'm running things inside sqlite itself, not another language. Thanks for the help! Bill

Re: [sqlite] Can a trigger update more than one column?

> can someone explain to me why folks try to accomplish the above using > TRIGGERs when the insert time can be set so easily by simply defining > the column as > > insert_ts DATETIME DEFAULT CURRENT_TIMESTAMP > > and last_upd_ts (or its equivalent) can set in the application logic > and

[sqlite] Can a trigger update more than one column?

Hi, There was some recent discussion about timestamp triggers, something I have been trying to get working on my own. Specifically, I have two fields, insert_ts and last_upd_ts, which I would like to be the insert time and last update time, respectively. However, when I try to write a trigger