I appreciate the prompt response to my prior question about triggers,
and have another one.
I'm using a python program to query an SQLite database from realtime
data (IDS data actually). Every time I get a hit in the database, I
want to record in that record an updated hitcount, and the timestamp
that it occured, something like:
cursor.execute("UPDATE detail SET lastaccessed=datetime('now'),
hitcount=? WHERE ROWID=?", [ row["hitcount"]+1, row["ROWID"] ])
where row[] is the row that was read in from the database.
However, I'm wondering if I can just do this via a trigger in the
database, so that I just tell sqlite something like:
cursor.execute("UPDATE detail WHERE ROWID=?", [row["ROWID"] ]);
Can I have a trigger do all the work, or do I need to SET something?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
