How to duplicate INSERTS into a seperate table?
- by Ash
An iPhone application I have installed uses an SQLite database to log entries with basic INSERTS and DELETES being performed on it.
However I wish to keep a permanent log of the INSERTS made to this table, so when an INSERT occurs, I want it to be written to another table also as to create a log.
I don't have access to the application source code in order to modify the SQL statements made, I do have access to the SQLite database.
Can I do this with triggers? If so can somebody provide a short example.